Friday, June 19, 2009 11:09 PM
I recently bought a book on Microsoft SQL Server 2008 Database Development but I am failing to attach the AdventureWorks2008_data sample database that
comes with the book. I am attaching this sample database under SQL SErver 2008 Enterprise Evaluation edition on my vista machine. I have done this the right way by attaching the database using SSMS but I am wondering why I am getting this error message.
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'RONALDLEE-PC\RONNIE'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
FILESTREAM feature is disabled.
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: 5591)
Could someone out there bail me since I have spent to much time on this.
Thanks in advance.
- Edited by ion860 Friday, June 19, 2009 11:11 PM
Friday, June 19, 2009 11:39 PMWhere is you Adventure works Mdf file and does this location 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' . exists ?
Now if it does that it is issue with you installation . FILESTREAM is not enabled by default. Look at this Bug for more details https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=349659&wa=wsignin1.0 and lets us know if you are able to resolve it
Please click the Mark as Answer button if a post solves your problem!
Saturday, June 20, 2009 1:04 AMHey there,
Actaully I have a AdventureWorks2008 folder in which I HAVE both th AdventureWorks2008_Data.mdf, AdventureWorks2008_Data.log and the Document folder that that has two files $FSLOG, 419cb40c-eaf5-4086-a60d-651ab009ceb0, and a file named filestream.hdr. Do you have any idea about this.
Is there anything i have to do to make this attachment work?
Saturday, June 20, 2009 5:21 AMhave you tried enabling filestream for the server?
EXEC sp_configure filestream_access_level, 2
Saturday, June 20, 2009 5:32 AMYes, I have done that.
Still there is no success.
Saturday, June 20, 2009 5:48 AMWhen I run the
sp_configure filestream_access_level, 2
I get the following:
Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
What does this mean?
Saturday, June 20, 2009 5:54 AMModeratorWhen you go to database properties, do you see under files: FileStreamDocuments?
It is pointing for me to: C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA
In this path, there is a Documents folder where I see the files you list.
Under filegroups there is DocumentFileStreamGroup with default checkmarked.
Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com
Saturday, June 20, 2009 6:04 AMHello Toth,
Yes, Under C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA, there is a documents folder with those documentsfileStreamGroup.
Do you have idea on what to do?
I really stack.
Saturday, June 20, 2009 6:12 AM
These files are there.
Is there any procedure in SQL SERVER 2008 for attaching file stream enabled databases?
This is really confusing.
Saturday, June 20, 2009 6:33 AM
I don't have this database (AdventureWorks2008_Data) attached. It has failed to attach.
Saturday, June 20, 2009 6:48 AMModeratorOK.
Let's go back to ground 0.
Download AdventureWorks2008 from the following link and follow setup instructions:
Let us know if works.
Kalman Toth, SQL Server Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com
- Marked As Answer by ion860 Saturday, June 20, 2009 7:21 AM
- Edited by Kalman TothMicrosoft Community Contributor, Moderator Wednesday, February 22, 2012 5:35 PM
Saturday, June 20, 2009 7:23 AMHello Toth,
Thank you for coming to my rescue.