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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Enable FileStream Access

Author  Topic 

clayton123123
Starting Member

1 Post

Posted - 2010-01-17 : 21:51:18
I have just installed SQL 2008 on a new PC and have attempted to restore a copy of the AdventureWorks2008 database from my old laptop (SQL Server 08) - i receive an error message that the restore failed because the FILESTREAM is disabled.

In Server Properties i have changed the FileStream Access Level to Full Access Enabled - and then restarted my SQL Server service. The Running Values are not being updated i.e. FileStream Access Level is disabled.

I have also tried restarting my PC.

Any advice greatly appreciated.

Thanks.
   

- Advertisement -