Adventure Works DB Attaching problem

[cpitc]

Hi

I am trying to attach the Adventure Works DB into SQL 2005 Express Studio. But when I attach the DB I ma getting this error message (below) any ideas how to get round this and get the DB loaded. Thanks

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)

For help, click:

http://go.microsoft.com/fwlink?Prod...35&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

[cpitc]

I ahve managed to get rid of the error message. The databse now looks like it is loading but presently says Adventure Works (In Recovery) Is this normal as it as been stood there for some time now.

Thanks

 

[cpitc]

Its Ok managed to load eventually, I had to go out of the management express and then back in and the database as loaded.

 

[SQLBill]

CPITC,

I'm not on this site much anymore, so I haven't seen your post until now...however, in the future when you attach or even restore a database, click on the database or servername and do a refresh.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875