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.
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
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 terminologythat Microsoft uses to describe software updates.
