Configuring FILESTREAM storage in SQL Server

FILESTREAM is a requirement where data storage for your MI cluster is provided by Microsoft SQL Server running on on-premises servers or in Azure virtual machines.

FILESTREAM enables Granta MI to access unstructured (BLOB) data, such as documents and images, stored on the file system. FILESTREAM is not automatically enabled in SQL Server. You must enable it 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 the SQL Server 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 the 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.