An error occurred while attaching the SQL Server Management studio express database.

if you use "SQL Server Management studio Express" and select SQL authentication when logging on to the local machine, an error is returned:

Error message:
Title: Microsoft SQL Server Management studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft. sqlserver. Express. smoenum)
For help, click: http://go.microsoft.com/fwlink? Prodname = Microsoft + SQL + server & link id = 20476
------------------------------
Additional information:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft. sqlserver. Express. connectioninfo)
------------------------------
Create File encountered operating system error 5 (Access denied .) While attempting to open or create the physical file 'C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data \ adventureworks_data.mdf '. (Microsoft SQL Server, error: 5123)
For help, click: http://go.microsoft.com/fwlink? Prodname = Microsoft + SQL + server & prodver = 09.00.3042 & evtsrc = MSSQLServer & evtid = 5123 & linkid = 20476
------------------------------
Buttons:
OK
------------------------------

:

 

After changing to Windows authentication, the process is successfully completed:

:
 

Appendix:
Adventureworksdb. MSI:
Http://download.codeplex.com/Project/Download/FileDownload.aspx? Projectname = msftdbprodsamples & downloadid = 11753 & filetime = 128230452260470000 & build = 17450

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/prince_vegeta/archive/2011/01/13/6134904.aspx