A client’s event log said the description for Event ID 18456 from source MSSQLSERVER cannot be found. Here is what it means and where to see the real error.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
After a patch, SQL Server would not start: assembly ISSERVER was not found in the SQL Catalog of database SSISDB. Here is what the ERRORLOG showed and the fix.
Installation Error – Updating Permission Setting for File Failed
A brand-new SQL Server 2016 install failed at the end with: Updating permission setting for file failed. Here is the quick fix for this installation error.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException
Patching my lab failed with MissingRegistryKeyException for the MSSQLSERVER Performance key. Here is how I read detail.txt and fixed it.
SQL SERVER – Startup Error: 17190, Severity: 16 – Initializing the FallBack Certificate Failed with Error Code: 1, State: 20
A client’s SQL Server would not start with Error 17190: initializing the FallBack Certificate failed. Here is how we found the cause on a call and fixed it.
SQL SERVER – Too Many SQLDump Files Consuming a Lot of Disk Space. What Should You Do?
SQLDump files are SQL Server’s stress signal, and a client had so many they filled the disk. Here is what causes them and what you should do about it.