SQL Server would not start after patching: Script Upgrade failed because ##MS_PolicyEventProcessingLogin## had been granted permissions. Here is the fix.
SQL SERVER – Installation Error – The Specified Driver is Invalid
SQL Server setup failed for several features, and the setup logs said ‘The specified driver is invalid’. Here are the symptoms, the cause and the fix.
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration for SQL is Inaccessible or Invalid
After server hardening, SQL Browser would not start and the event log said the SQL configuration for SQL is inaccessible or invalid. Here is the fix.
SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version
Upgrading an AlwaysOn replica from SQL 2014 to 2016, databases got stuck and the ERRORLOG showed error 946, cannot open database version 782. Why and the fix.
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.
SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
SQL Server shut itself down with error 566: an error occurred while writing an audit trace. Here is what the ERRORLOG showed and how to fix it.
SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed
SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.