2

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

<{781FAE78-09AB-4EE5-B051-67747BDB19E3}>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.
<{1038F43D-3391-45F7-B1B3-BADF26459429}>Failed to initialize CFsaShareFilter: Error 0x80070002 (-2147024894)

<{1038F43D-3391-45F7-B1B3-BADF26459429}>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 <X64> (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

1
  • about the first error: the RsFx device is not found. Check if RsFx driver is started. have you seen this workaround? Not your exact situation, but could help.
    – Ronaldo
    Commented Apr 21, 2020 at 11:44

1 Answer 1

3

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. enter image description here enter image description here

I hope this will help

2
  • This worked - I wonder why doing this via the registry was causing problems Commented Apr 21, 2020 at 14:48
  • Sometime, the Gui trigger a lot of thing in the background (like permission setting for example). Changing only a line in the registery does not trigger the same operations. I would guess it has something to do with that :D Commented Apr 21, 2020 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.