To properly use the SQL Server, change the settings for SQL Configuration to allow for database upgrades.
You cannot enable FILESTREAM on a 32-bit version of SQL Server running on a 64-bit
operating system. If you try, the following error message is displayed:
FILESTREAM is not supported on this instance of SQL Server.
FILESTREAM is not supported on versions of SQL Server earlier than SQL Server 2008, or an instance of SQL Server running under WOW. To enable FILESTREAM, upgrade the instance of SQL Server, or if running under WOW, install the 64-bit version of SQL Server 2008. For more information, see http://msdn.microsoft.com/en-us/library/cc645923.aspx.
To enable FILESTREAM:
-
Click Windows Start > Microsoft SQL Server 20xx > SQL Server Configuration Manager.
-
Click SQL Server Services in the left pane and then click SQL Server (MSSQLServer) in the right pane. On the Action menu, click Properties.
-
On the FILESTREAM tab, check the first two check boxes:
-
Enable FILESTREAM for Transact-SQL access
-
Enable FILESTREAM for file I/O streaming access
-
-
Type the name of the Windows share in the Windows share name field.
-
If remote clients need access to the FILESTREAM data stored on this share, select the Allow remote clients to have streaming access to FILESTREAM data check box.
-
Click Apply, and then click OK to close the SQL Server Properties window.
-
Click Windows Start > Microsoft SQL Server (version) > SQL Server Management Studio.
-
In SQL Server Management Studio, click New Query to display the Query Editor.
-
In Query Editor, type the following code:
EXEC sp_configure filestream_access_level, 2 RECONFIGURE
-
Click Execute.
-
In SQL Server Configuration Manager, click SQL Server Services in the left pane and then click SQL Server (MSSQLServer) in the right pane. On the Action menu, click Restart.
-
Make sure the SQL Server State is Running, and then close the SQL Server Configuration Manager window.