How to fix Error 5583 on Windows Server 2025 / Windows 11

by

Troubleshooting Guide: SQL Server Error 5583 — Invalid enable_level Parameter for sp_filestream_configure

Why This Error Happens

This error occurs when the enable_level parameter passed to sp_filestream_configure is set to a value outside the valid range of 0–3, or when it is set to a value higher than what the FILESTREAM feature is actually enabled for at the Windows Services level (via SQL Server Configuration Manager). Essentially, SQL Server validates the requested T-SQL configuration level against the OS-level FILESTREAM access setting, and a mismatch — often caused by skipping the Configuration Manager step or passing an incorrect integer/string value — triggers this failure. It can also happen if FILESTREAM was never enabled at the instance level prior to running the stored procedure.

Step-by-Step Resolution Guide

Step 1: Enable FILESTREAM at the Windows Service Level

  • Open SQL Server Configuration Manager (search for SQLServerManager17.msc or the version-specific equivalent on Windows Server 2025 / Windows 11).
  • Navigate to SQL Server Services, right-click your instance (e.g., SQL Server (MSSQLSERVER)), and select Properties.
  • Go to the FILESTREAM tab and check Enable FILESTREAM for Transact-SQL access.
  • Optionally check Enable FILESTREAM for file I/O streaming access if remote/file-share access is needed.
  • Click Apply, then restart the SQL Server service for changes to take effect.

Step 2: Verify the Correct enable_level Value

  • Valid values for enable_level are strictly: 0 (disabled), 1 (T-SQL access only), 2 (T-SQL + local I/O streaming), or 3 (T-SQL + local and remote I/O streaming).
  • Re-run the procedure with a valid integer value, for example:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
  • Avoid passing enable_level = 2 or 3 if you have not enabled the corresponding checkbox in Step 1 — this mismatch is the most common cause of Error 5583.

Step 3: Use sp_configure Instead if the Procedure Still Fails

  • If sp_filestream_configure continues to throw the error, bypass it and configure directly at the instance level:
EXEC sp_configure 'filestream access level', 1
RECONFIGURE
  • Restart the SQL Server service from Services.msc or Configuration Manager after making this change.

Step 4: Restart Dependent Services

  • Restart the SQL Server (instance name) service.
  • Restart SQL Server VSS Writer if FILESTREAM is used with backup/snapshot tools.
  • Confirm the Windows user account running SQL Server has the necessary local permissions on the FILESTREAM data folder path.

Alternative or Verification Steps

  • Run EXEC sp_configure 'filestream access level' and confirm the run_value column matches the level you intended to set (0–3).
  • If the error persists, check Windows Event Viewer (Application log, source: MSSQLSERVER) for additional detail tied to Error 5583, and confirm no Group Policy is blocking the FILESTREAM registry key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL17.<InstanceName>\MSSQLServer\FilestreamShareName.