SQL Server Management Studio Express附加資料庫出錯

如果使用"SQL Server Management Studio Express"，在本機登入時選擇 SQL 認證，那麼會報錯：

錯誤資訊：
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&LinkId=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(拒絕訪問。) 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
------------------------------

：

 

改為 WINDOWS 認證後，順利完成:

：
 

附：
AdventureWorksDB.msi：
http://download.codeplex.com/Project/Download/FileDownload.aspx?ProjectName=MSFTDBProdSamples&DownloadId=11753&FileTime=128230452260470000&Build=17450

本文來自CSDN部落格，轉載請標明出處：http://blog.csdn.net/prince_vegeta/archive/2011/01/13/6134904.aspx