DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops

Enable & Configure

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine.

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the

Database Engine. This topic describes how to enable FILESTREAM by using SQL

Server Configuration Manager.

  1. On the

menu, navigate to

, and

then select

Configuration Manager.

  1. In the list of services, right-click

Services

, and then select.

  1. In the

Configuration Manager

snap-in, locate the instance of SQL Server on

which you want to enable FILESTREAM.

  1. Right-click the instance, and then select.

  2. In the

Properties

dialog box, select the

tab.

  1. Select the

check box.

  1. If you want to read and write FILESTREAM data from Windows, select. Enter the name of the Windows share in the

box.

  1. If remote clients must access the FILESTREAM data that is stored on this share, select.

  2. Select.

  3. In SQL Server Management Studio, select

to display the Query Editor.

  1. In Query Editor, enter the following Transact-SQL code:

７

Note

On newer versions of Windows, follow these instructions to.