1

SQL Server "FILESTREAM Access Level" is stuck at disabled. I have checked all ways by SSMS and queries.

After restart, also my configured value is Full Access but Running value is disabled:

After restart, also my configured value is Full Access but Running value is disabled

Windows 10 Enterprise v1703 Build 15063 Redstone 2

Makyen
  • 31,849
  • 12
  • 86
  • 121
Masoud Ehsani
  • 51
  • 4

3 Answers3

3

After lots of efforts finally I found the solution to my problem: 1- Computer Management -> Services and Applications -> SQL Server Service -> SQL Server (MSSQLSERVER{Your Instance Name}) 2- Change User to an administrator user in Log On tab 3- Enable check check boxes considering your goal from FILESTREAM tab

Masoud Ehsani
  • 51
  • 4
0

This Windows 10 Creators Update intoduced a problem with Filestream when the SQL Server service account is a non-admin. A fix has since been released. You should no longer need to run SQL Server as an admin if you are current with Windows 10 updates.

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71
  • Fix? I have this issue too. Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19:56:59 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Home Single Language 10.0 (Build 18363: ) SQL Server Management Studio 15.0.18330.0 SQL Server Management Objects (SMO) 16.100.37971.0 Microsoft Analysis Services Client Tools 15.0.19040.0 Microsoft Data Access Components (MDAC) 10.0.18362.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.18363 – Alocyte Jun 02 '20 at 10:06
0

MSDN Social

My experience is that the SQL Management Studio does not facilitate enabling FILESTREAM. This is done on the SQL Server Configuration Manager, on the instance... Tab on SQL Server instance in Configuration Manager

Then, when creating a FILESTREAM folder, its accessed by \\[machine name]\[SQL Instance]\[TableName]

Alocyte
  • 293
  • 4
  • 13