Set Up FILESTREAM on a Failover Cluster

Applies to: SQL Server

This topic describes how to enable FILESTREAM on a failover cluster. Before you try this procedure, you should understand failover clustering and have FILESTREAM enabled. For information about how to enable FILESTREAM, see Enable and Configure FILESTREAM.

To set up FILESTREAM on a failover cluster

1. Set up the primary node for the failover cluster.

   After the setup finishes, enable FILESTREAM on the primary node by using SQL Server Configuration Manager. This enables the settings that require Windows Admin privileges. If remote access is required, select Allow remote clients to have streaming access to FILESTREAM data. This will create a file-share cluster resource.

2. Set up a passive node.

   After the setup finishes, enable FILESTREAM on the passive node by using SQL Server Configuration Manager. The name that you specify for Windows Share Name must be the same across all nodes in the cluster.

3. To add more passive nodes, repeat step 2.

4. After all the nodes are added, complete the process by executing the sp_configure stored procedure on each instance of SQL Server.

5. To add and enable additional nodes to the cluster at any time, you can repeat steps 2, 3, and 4.

See Also

Server Configuration Options (SQL Server)
Create a New SQL Server Failover Cluster (Setup)
Remove a SQL Server Failover Cluster Instance (Setup)
Add or Remove Nodes in a SQL Server Failover Cluster (Setup)