MS SQL Server Dev was installed, followed by Management Studio. In the server settings enabled filestream, as stated on off. site:

enter image description here

Created a new database and wanted to create a filegroup, but I can't do it. And without it I can not create a table. What could be the problem?

enter image description here

  • Configuration updated EXEC sp_configure filestream_access_level, 2 RECONFIGURE ? - vikolyada
  • @vikolyada yes ... - Alexander Semikashev
  • What is displayed in the server properties in the filestream access level parameter? - vikolyada
  • @vikolyada Full access enabled - Alexander Semikashev
  • Try to add via t-sql - alter database passoffice add filegroup fsPassoffice contains filestream; go alter database passoffice add filegroup fsPassoffice contains filestream; go . What error gives? - vikolyada

1 answer 1

Find out the reason in the chat . Problem in Window 10 Creators Update. Description from MSSQL Tiger Team .

Possible solutions:

  • change the account from which the SQL Server service runs on the LocalSystem;
  • change the account from which the SQL Server service runs on a domain user with local administrator rights on the machine;
  • if you use the NT SERVICE\MSSQL$InstanceName account to start, then make sure that it has local administrator rights;
  • uninstall Creators Update and return to the previous build of Windows 10.
  • The first solution worked. - Alexander Semikashev