Enable File Stream SQL Server 2017 I am trying to enable file stream on Microsoft SQL Server 2017, on a Windows Core 2019 Server.

I have changed the registry settings at the following location to enable it as there is no GUI. I set the value to 3

ServerName\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.InstanceName\MSSQLServer\Filestream.EnabledLevel


After This I restarted

I have also installed the latest Cumulative update (20) as I know there where issues with Driver signing.

After This I restarted

I am seeting the following Errors in the log file at C:\Program Files\Microsoft SQL Server\MSSQL14.InstanceName\MSSQL\Log

&lt;{781FAE78-09AB-4EE5-B051-67747BDB19E3}&gt;RsFxMgmtInitialize failed (the RsFx device is not found. Check if RsFx driver is started.): Error 0x80070002 (-2147024894)
2020-04-21 08:56:03.94 spid5s      FILESTREAM: failed to connect to kernel driver RsFx0503.
&lt;{1038F43D-3391-45F7-B1B3-BADF26459429}&gt;Failed to initialize CFsaShareFilter: Error 0x80070002 (-2147024894)

&lt;{1038F43D-3391-45F7-B1B3-BADF26459429}&gt;Failed to initialize CFsaShareFilter: Error 0x80070002 (-2147024894)

2020-04-21 08:56:03.94 spid5s      FILESTREAM: effective level = 0, configured level = 2.
2020-04-21 08:56:03.94 spid5s      FILESTREAM feature could not be initialized. The operating system Administrator must enable FILESTREAM on the instance using Configuration Manager.


SELECT @@VERSION  

Microsoft SQL Server 2017 (RTM-CU20) (KB4541283) - 14.0.3294.2 (X64)   Mar 13 2020 14:53:45   Copyright (C) 2017 Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 &lt;X64&gt; (Build 17763: ) (Hypervisor) 


I got this working on one server and cannot get it working on the second one.
There is also a version of sql 2019 on this box

Any help? Also any advice on getting this working on a cluster
I'm not a big fan of changing stuff directly in the registry.

You can use "computer management" and remotly connect to your core server. From there, you can enable FileStream and configure it.



I hope this will help