FILESTREAM feature is disabled

sql filestream
Zteck picture Zteck · Jan 13, 2014 · Viewed 49k times · Source

I have a database set up with FILESTREAM enabled on it (if you go to Properties\Advanced on the instance, it shows that FILESTREAM is enabled). I also ran the sp_configure script on it after doing this to enable the access (to make sure it was enabled). But...as soon as I try to alter the database and add the filegroup to it, it says that the feature is disabled.

I have it enabled on other instances on the same computer, and those work fine. It is only this one that is not working. I have not been able to find any good suggestions as to why it is not working.

It is a SQL 2008 R2 instance.

Answer

mojo picture mojo · Apr 16, 2015

I was unable to script this, (using the link provided by user1977061), as the MSSQLService requires a restart afterwards to apply the change. Even after doing this it didn't work, and instead I had to manually configure FILESTREAM usage via:

  1. SqlServer Configuration Manager
  2. Sql SQL Server Services
  3. SQL Server(MSSQLSERVER) [Properties]
  4. FILESTREAM tab - enable the first 2, and optionally 3rd check box.

Look at the SQLServer properties > Advanced > Running Values value for "Filestream Access Level" to ensure that the FILESTREAM is actually enabled if in doubt.

Related questions

SQL Server FILESTREAM limitation

I am looking at FILESTREAM attribute in SQL Server to store files in it. I understand it stores the files on hard drive and stores the file pointer/path information in DB. Also, maintains transactional consistency in the process. There …

Read More
FILESTREAM files being left behind after row deleted

I have successfully set up FILESTREAM on my SQL 2008 server; however I've noticed that even when I have deleted rows containing FILESTREAM data, the physical data file doesn't seem to get deleted. By the physical file, I mean the file …

Read More
Check SQL Server 2008 Filestream status

I'm using the SQL Server 2008 filestream feature in one of my projects, is there a way to check the filestream status (if it's enabled or not) using a query?

Read More