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

by

Troubleshooting Guide: SQL Server Error 5044

Why This Error Happens

Error 5044 occurs when SQL Server removes a configuration object, trace flag, or server-level setting because it has been deprecated, superseded, or deemed invalid during startup or runtime reconfiguration. This typically happens after an in-place upgrade to SQL Server 2025 where legacy configuration entries in sys.configurations are no longer supported by the new engine. It can also surface when corrupted or orphaned metadata remains in the msdb or master system databases following an incomplete patch installation.

Step-by-Step Resolution Guide

Step 1: Review the SQL Server Error Log for Context

  • Open SQL Server Management Studio (SSMS) and connect to the affected instance.
  • Navigate to Management > SQL Server Logs and locate the exact timestamp of Error 5044.
  • Identify the specific %S_MSG value and configuration name referenced in the message text to determine which setting was removed.
  • Alternatively, run EXEC xp_readerrorlog 0, 1, N'5044'; in a query window to filter directly for this event.

Step 2: Validate and Reset Server Configuration Values

  • Run sp_configure with no parameters to list all current advanced and standard options.
  • Compare the output against Microsoft’s official SQL Server 2025 configuration reference to spot deprecated entries.
  • If a legacy option (e.g., an old trace flag or advanced option) is flagged, remove it using:
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure '<deprecated_option_name>', 0;
RECONFIGURE WITH OVERRIDE;

Step 3: Rebuild or Repair System Database Metadata

  • Stop the SQL Server service via SQL Server Configuration Manager.
  • Launch a repair using Setup: Setup.exe /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=<YourAdminAccount> (only if master database corruption is confirmed).
  • If rebuilding is not required, instead run DBCC CHECKDB('master') WITH NO_INFOMSGS, ALL_ERRORMSGS; to confirm system database integrity before restarting the service.

Step 4: Apply the Latest Cumulative Update

  • Download and install the latest Cumulative Update (CU) for SQL Server 2025 from the Microsoft Update Catalog.
  • Run the installer as Administrator on Windows Server 2025 or Windows 11 to ensure patched binaries replace any files affected by the removed configuration.
  • Restart the SQL Server service and monitor the error log for recurrence of Event ID 5044.

Alternative or Verification Steps

  • After applying fixes, restart the SQL Server service and re-check the Error Log for 30 minutes of uptime to confirm Error 5044 does not reappear.
  • If the issue persists, restore the master database from a pre-upgrade backup taken before the SQL Server 2025 migration, then reapply only validated configuration changes.