Troubleshooting Guide: Error 1969 — Default FILESTREAM Filegroup Not Available

Why This Error Happens

This error occurs when a database attempts to perform a FILESTREAM operation, but no filegroup has been marked as the DEFAULT for FILESTREAM data storage. It commonly happens after a database restore or migration where the FILESTREAM filegroup properties were not preserved, or when FILESTREAM was never properly initialized at the instance level in SQL Server 2025. Additionally, this can occur if the Windows Server 2025 instance-level FILESTREAM access level is disabled, preventing SQL Server from recognizing any filegroup as a valid default target.

Step-by-Step Resolution Guide

Step 1: Enable FILESTREAM at the Instance Level

• Open SQL Server Configuration Manager on Windows Server 2025 / Windows 11.
• Navigate to SQL Server Services, right-click your instance (e.g., MSSQLSERVER), and select Properties.
• Go to the FILESTREAM tab and check Enable FILESTREAM for Transact-SQL access.
• Restart the SQL Server service for changes to take effect:

  net stop MSSQLSERVER
  net start MSSQLSERVER

Step 2: Configure the FILESTREAM Access Level via T-SQL

• Open SQL Server Management Studio (SSMS) and run the following to confirm the instance-level setting:

  EXEC sp_configure filestream_access_level;

• If the value is 0, enable it with:

  EXEC sp_configure filestream_access_level, 2;
  RECONFIGURE;

Step 3: Mark a Filegroup as the Default FILESTREAM Filegroup

• Check existing filegroups in the target database:

  SELECT name, type_desc, is_default 
  FROM sys.filegroups;

• If no FILESTREAM filegroup exists, create one:

  ALTER DATABASE YourDatabase 
  ADD FILEGROUP FileStreamGroup CONTAINS FILESTREAM;

• Set it as the default:

  ALTER DATABASE YourDatabase 
  MODIFY FILEGROUP FileStreamGroup DEFAULT;

Step 4: Add a File to the FILESTREAM Filegroup

• Ensure the filegroup actually has a container file path on disk (e.g., C:\SQLData\FileStreamData):

  ALTER DATABASE YourDatabase 
  ADD FILE (
      NAME = FileStreamDoc, 
      FILENAME = 'C:\SQLData\FileStreamData'
  ) TO FILEGROUP FileStreamGroup;

• Confirm the folder exists and the SQL Server service account has Full Control permissions on it.

Alternative or Verification Steps

• Run SELECT * FROM sys.database_filestream_options; to confirm the FILESTREAM directory and non-transacted access level are correctly configured for the database.
• If the error persists after configuration, detach and re-attach the database, or restore it fresh and re-apply the FILESTREAM filegroup settings before re-inserting FILESTREAM-enabled tables.