506
Part V: Enterprise Data Management
FILESTREAM Access Level
SQL Server 2008 introduced a new feature called FILESTREAM that enables you to store
structured data in the database and associated unstructured (that is, BLOB) data such
as text documents, images, and videos directly in the NTFS fi le system. By default,
FILESTREAM is not enabled. Before you can start using FILESTREAM, you must enable
FILESTREAM. You can enable FILESTREAM during the SQL Server 2011 installation in the
Database Engine Confi guration page of the setup. You can also enable the FILESTREAM fea-
ture after the installation using the SQL Server Confi guration Manager as follows:■ (^) Open SQL Server Confi guration Manager from Start ➪ Programs ➪ Microsoft SQL
Server 2012 ➪ Confi guration Tools ➪ SQL Server Confi guration Manager.
■ (^) Under SQL Server Confi guration Manager, click SQL Server Services.
■ (^) Right-click the SQL Server service (on the right side) on which you want to enable
FILESTREAM and select Properties.
■ (^) Click the FILESTREAM tab (see Figure 19-11) and select the Enabled FILESTREAM for
Transact-SQL Access check box.
FIGURE 19-11
Enabling FILESTREAM feature using SQL Server Confi guration Manager.
■ If you want to read and write FILESTREAM data from Windows, select the Enable
FILESTREAM for File I/O Access check box. Enter the name of the Windows share in
which the FILESTREAM data will be stored in the Windows Share Name box.
c19.indd 506c19.indd 506 7/30/2012 5:43:05 PM7/30/2012 5:43:05 PM
http://www.it-ebooks.info