FILESTREAM feature can't be enabled if you use cluster shared volumes

Create a SQL Cluster instance.

Create Cluster Shared Volume

    

Please note. No Share storage is added into SQL Server.

Open SQL Server configuration manager.

Check 'Enable FileStream for Transact-SQL access'

Check 'Enable FileStream for I/O access' , it will fail.

There was an unknown error applying the FILESTREAM settings. Check the parameters are valid.(0x800710dc)

 

Workaround

===

Add a shared storage and set dependencies.

After that you are able to check the feature in sql server configuration manger.

After it's enabled, you can drop the disk or remove the dependencies.

 

This issue will be fixed in sql server 2017 cu14 or later cu...

 

posted on 2019-02-22 03:29  stswordman  阅读(420)  评论(0编辑  收藏  举报