FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 or 2016 in Windows 10 Creators Update

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core More

Symptoms


Consider the following scenario:

  • You install Microsoft SQL Server 2014 or 2016 on a Windows 10 device.
  • You enable the FILESTREAM feature at the instance level.
  • You create a database that contains a FILESTREAM data container.

After you apply the Windows 10 Creators Update, when you start the database that contains the FILESTREAM data container, you may receive the following FILESTREAM feature is disabled error message in the error log.

Date/Time Error: 5591, Severity: 16, State: 5.
Date/Time FILESTREAM feature is disabled.

Also, when SQL Server starts, you may notice the following messages in the SQL Server error log:

Date/Time Server Microsoft SQL Server 2016 (RTM-GDR) (KB3210111) – 13.0.1728.2 (X64)
Date/Time
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Enterprise 6.3 <X64> (Build 15063: ) (Hypervisor)
Date/Time Server The service account is ‘CustomerName\MSSQL$InstanceName’. This is an informational message; no user action is required.
<{7715B5FC-837B-46C9-A28B-A7867FC86023}>RsFxFt.Dll::RsFxNsoInitialize failed: Error 0x80070005 (-2147024891)
<{C580416B-A13E-4ECD-B61B-AAFAE39E5E35}>Failed to initialize the CFsaShareFilter interface
<{1038F43D-3391-45F7-B1B3-BADF26459429}>Failed to initialize CFsaShareFilter: Error 0x80070005 (-2147024891)
Date/Time FILESTREAM: effective level = 0, configured level = 2, file system access share name = ‘InstanceName’.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 4 for SQL Server 2016 SP1

       Cumulative Update 6 for SQL Server 2014 SP2

Note This fix will work for users who have not updated their Windows 10 version, because the issue is already fixed in the latest Windows 10 version. 

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.