Ask Learn
Preview
Please sign in to use this experience.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Starting Windows 10 version 1607 (Redstone 1) and Windows Server 2016, there is a new enforcement for kernel drivers, requiring that all kernel drivers must be signed by Windows Hardware Developer Center Dashboard portal (Dev Portal) as documented by Windows hardware certification blog. It means that Windows will not load the kernel drivers that were not signed by Windows Hardware Developer Center starting Windows 10 version 1607 (Redstone 1) and Windows Server 2016.
The SQL16 RTM version of the Filestream RsFx driver is signed by Windows Hardware Developer Center Center Dashboard portal which allows installation of SQL 2016 RTM to succeed on Windows Server 2016 and Windows 10, but the latest servicing release of SQL 2016 viz SQL 2016 RTM CU2 of RsFx driver is signed by the certificate not issued by sysdev portal which leads to the Filestream RsFx driver blocked and failing to load during installation of SQL 2016 + CU2 when the following conditions are met:
Note: Hyper-V Gen2-type VMs has SecureBoot enabled by default hence the users are more likely to hit this issue when installing SQL 2016 + CU2 on Windows Server 2016/Windows 10 on Gen2 Hyper-V VM. However, the issue can occur on physical servers as well if SecureBoot is turned ON.
The following table summarizes the end result when trying to install SQL 2016 on Windows Server 2016 or Windows 10 (version 1607 and above) with SecureBoot turned ON,
Depending on the feature selection during installation in SQL 2016 + CU2 setup on Windows Server 2016 or Windows 10 (version 1607 and above), you can see following error or warning message
Figure 1: SQL 2016 + CU2 Setup error when Filestream is installed as part of setup installation
Figure 2: SQL 2016 + CU2 Setup error when Filestream is not installed as part of setup installation.
TheSQL Product team is aware of the issue and is working on getting RsFx driver signed by Windows Hardware Developer Center Dashboard portal (Dev Portal) in the future release of SQL Server. In the interim, we have following recommendation for the users
The fix for the issue is included in SQL Server 2016 SP1. We highly recommend customers to apply SQL Server 2016 SP1, to avoid the issue.
Parikshit Savjani
Senior Program Manager (@talktosavjani)
Please sign in to use this experience.
Sign in