Forum Discussion

dcarapic's avatar
dcarapic
Copper Contributor
Jan 25, 2024

SQL Server 2019 - unable to create filestream database on ReFs file system

I'm trying to create a filestream database on ReFs.

I keep getting the following error:

 

Unable to open the physical file "c:\....\db\FileStream". Operating system error -1073740577: "0xc00004df(failed to retrieve text for this error. Reason: 317)".

 

Anyone knows what could be the problem?

    • dcarapic's avatar
      dcarapic
      Copper Contributor
      I can create other databases in the same folder (and have done so) without any issues. I've also set the ACL to Everyone - Full control and it did not help.
      Only the creation of FileStream file fails for some reason.
      • Make sure the sql service account has all rights to the disk. I don’t believe this is an issue related to ReFS .

Resources