Enable FILESTREAM on SQL Server 2008R2
FILESTREAM is a feature of SQL 2008 that supports BLOB file storage on NTFS file shares. This feature is also supported by SharePoint 2010, but first you’ll need to enable the feature in SQL 2008R2 server, default the FILESTREAM feature is disabled during the SQL 2008 installation.
To enable FILESTREAM feature on SQL Server 2008:
- Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)
- Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)
- Click the FILESTREAM tab and select the checkboxes to enable FILESTREAM and enter a share name for the files, as shown