Export (0) Print
Expand All

Set Up FILESTREAM on a Failover Cluster

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft