2
Vote

Error while attaching database

description

I am getting following error while attaching the database in management studio.

 

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(Access is 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)

 

 
There is no connection for me. I am logged in as administrator and have all rights.
Does anyone have some idea about it?

comments

antonsea wrote Mar 13, 2009 at 3:16 AM

It happened exactly the same with me.
Only that I'm using Microsoft SQL Server Management Studio (not the Express version).