June 3, 2015 at 8:41 pm
I have a SQL Server book from MS Press that uses Adventureworks2008 for demos and examples. I have been trying for hours to attach this database but keep getting errors. The other sample databases like Adventureworks2008DW had no problem attaching.
The errors run me around in circles with things about Access Denied and file not found. I have followed all of the suggestions I could find on the web (change the log on to "local service", check permissions, run mgmt. studio as admin) and moving the file to different directories. Nothing works and I always end up at the message below. Could anyone please help me to get this installed? Thank you.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'DOMTER-YOGA'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL
+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-
0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach
+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The operating system returned the error '2(The system cannot find the file specified.)' while attempting
'FsFileHeader::Open' on 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents'.
A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server
\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' may be incorrect. Diagnose and correct additional errors, and retry the
operation.
Could not open new database 'AdventureWorks2008'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 3634)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL
+Server&ProdVer=10.50.2550&EvtSrc=MSSQLServer&EvtID=3634&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
June 4, 2015 at 7:55 am
I had a similar issue with a setup a while back, from what I recall the AdventureWorks2008 database is slightly different to the others (you may be able to find info on this online) and I just had to enable firestream: https://msdn.microsoft.com/en-us/library/cc645923(v=sql.105).aspx
June 4, 2015 at 5:37 pm
You can download a version of the 2008 database from codeplex that doesn't have filestream enabled. That will make things much easier.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2015 at 7:51 pm
I looked in configuration manager and filestream is already enabled.
June 4, 2015 at 7:54 pm
my concern is that the version that is now on codeplex wont match the samples and examples from the book. (The book is quite old and MS Press no longer makes or supports it.)
What is it about this "filestream" that is making this process so difficult?
June 5, 2015 at 7:26 am
Yes, it does.
June 5, 2015 at 9:42 am
No, not in the Documents folder. They reside in the DATA folder.
June 5, 2015 at 1:44 pm
There are small changes to Adventureworks within any given version of it, but they're not very radical. I use it for all the books I write. Many of the examples work between versions let alone within a version. I'd suggest just going for the simple work and getting it online so you can use it rather than pound your head against a wall.
Rereading the error message, it looks like something is wrong or missing with the Filestream configuration.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply