Enabling and configuring FILESTREAM on your SQL instance

FILESTREAM storage is a requirement for MI clusters, enabling nodes to access BLOB data on the cluster's SQL instance.

FILESTREAM isn't automatically enabled in SQL Server. You must enable FILESTREAM by using SQL Server Configuration Manager and SQL Server Management Studio.

  1. Open SQL Server Configuration Manager.
  2. In the list of services, right-click SQL Server Services, and then click Open. 
  3. In the SQL Server Configuration Manager snap-in, locate your cluster SQL instance, right-click it  and then click Properties
  4. In the SQL Server Properties dialog box, go to the FILESTREAM tab. 
  5. Select the Enable FILESTREAM for Transact-SQL access check box. 
  6. Click Apply. 
    This change will not be applied until the SQL Server is restarted.
  7. In the main SQL Server Configuration Manager window, right-click and restart your SQL Server instance.
Now change the FILESTREAM access level for this instance:
  1. Open SQL Server Management Studio.
  2. Right-click your SQL instance to open the Server Properties window.
  3. Click Advanced and locate the FILESTREAM section.
  4. Set FILESTREAM Access Level to Full Access Enabled.
  5. Click OK to save your changes.