Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lesponce
Starting Member
8 Posts |
 Posted - 2012-09-06 : 15:37:52
|
| I'm trying to install the adventureworks2008 database and I a large number of people having the same problem. If attach the database, I get this error message:Unable to open the physical file blah blah mssql\data\documents....Could not open new database 'AdventureWorks2008'. CREATE DATABASE is aborted. on the other hand, I get error message 'access denied' if I run this query: USE [master] GO CREATE DATABASE [AdventureWorks2008] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AdventureWorks2008_Data.mdf' ), ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AdventureWorks2008_Log.ldf' ), FILEGROUP [PRIMARY] CONTAINS FILESTREAM DEFAULT ( NAME = N'Documents', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Documents' ) FOR ATTACH GO Let me know if you have dealt with this. Any feedback is greatly appreciated. Thx. |
|
|
|
|
|
AdventureWorks2008 Installation Problem