5 Appendix > 5.2 Enabling FILESTREAM in SQL Server 2008 R2
5.2 Enabling FILESTREAM in SQL Server 2008 R2
You must enable FILESTREAM on the Database Engine instance of the SQL Server. The following steps describe how to enable FILESTREAM by using the SQL Server Configuration Manager.
1. From the Start menu, go to All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | SQL Server Configuration Manager.
2. In the list of services, right-click SQL Server Services, and select Open from the context menu.
C:\Users\USDIJA\Documents\backup\TEMS Discovery\TD DocToHelp Projects\MASTER IPP Collection with PNGs\SQL Server Configuration Manager.png
 
3. In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
4. Right-click the instance, and select Properties from the context menu. The SQL Server Properties dialog will be displayed.
C:\Users\USDIJA\Documents\backup\TEMS Discovery\TD DocToHelp Projects\MASTER IPP Collection with PNGs\SQL Server Properties.png
 
5. Go to the FILESTREAM tab. Make the settings described below, and then click Apply.
C:\Users\USDIJA\Documents\backup\TEMS Discovery\TD DocToHelp Projects\MASTER IPP Collection with PNGs\SQL Server Properties - FILESTREAM.png
 
− Select the Enable FILESTREAM for Transact-SQL access check box.
− If you want to read and write FILESTREAM data from Windows, select Enable FILESTREAM for file I/O streaming access. Enter the applicable name in the Windows Share Name box.
− If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.
 
6. In SQL Server Management Studio, click New Query to display the Query Editor.
7. In the Query Editor, enter the following Transact-SQL code:
 
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
 
8. Click Execute.
9. Restart the SQL Server service.
 
Heading
Heading
Heading
Heading
Heading
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data