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