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