To enable FILESTREAM feature, go to ‘SQL Server configuration Manager’ and right click on instance of SQL Server Service and select ‘properties’.
The property page will show an additional tab labeled ‘FILESTREAM’, which looks exactly the same as the FILESTREAM configuration page shown as part of the installation wizard.
The FILESTREAM feature can be enabled by setting the appropriate options on this page.If you wish to automate this process, you could try running the VBScript given at How to enable FILESTREAM from the command line. Once FILESTREAM feature is enabled, the next step is to configure FILESTREAM Access Level.Select the ‘Advanced’ tab and change the ‘FILESTREAM Access Level’ to ‘Transact-SQL Access enabled’ or ‘Full access enabled’.Alternatively, ‘FILESTREAM Access Level’ can be configured using TSQL by running the following statement.FILESTREAM feature may be enabled with three different levels of access to the FILESTREAM data, namely: If you are installing SQL Server 2008 in ‘Unattended mode’, you can use /FILESTREAMLEVEL and /FILESTREAMSHARENAME configuration options to configure FILESTREAM features.
For more information about installing SQL Server 2008 in ‘Unattended mode’, see How to: Install SQL Server 2008 from the Command Prompt Enabling FILESTREAM feature on a SQL Server 2008 Instance, installed without FILESTREAM features, would require a little more work.
If the SQL Server 2008 instance is already installed without FILESTREAM feature, it can still be enabled following the steps explained later in this section.
The easiest way to enable FILESTREAM feature is to do so as part of the installation process.
The last parameter to sp_configure specifies the Access Level, where 0 means ‘Disabled’, 1 means ‘Transact-SQL Access Enabled’ and 2 means ‘Full Access Enabled’ Once you have an instance of SQL server 2008 with FILESTREAM feature enabled, you are ready to go ahead and create FILESTREAM enabled databases.
When you create a FILESTREAM enabled database, the FILESTREAM data should be placed in a separate file group having a special attribute that indicates that the file group contains FILESTREAM data.
This is an additional step that is required only if you configure FILESTREAM after the installation of SQL Server.