SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.
SQL SERVER – Login Failed – Server is in Script Upgrade Mode – Deleting Collection Set “Utility Information”
Login failed because the server was in script upgrade mode, stuck while deleting collection set ‘Utility Information’. Here is how we got past it.
SQL SERVER – Could Not Load the DLL xpstar.dll, or One of the DLLs it References
After patching, SQL Server would not start: could not load the DLL xpstar.dll, or one of the DLLs it references. What the ERRORLOG showed and the fix.
What is the Initial Size of TempDB? – Interview Question of the Week #120
Question: What is the Initial Size of TempDB? Trust me, this question is way more complicated than you read in one line.
SQL SERVER – Unable to Start SQL Service – OS Error 5 (Access is denied.) for TempDB
I moved TempDB files and SQL Server would not start, with OS Error 5 (Access is denied). The message was misleading, and here is the real mistake.
SQL SERVER – FIX: The SQL Server Failed to Initialize VIA Support Library [QLVipl.dll]
SQL Server would not start: failed to initialize VIA support library [QLVipl.dll]. The fix was in SQL Server Configuration Manager, and here is how.
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
Another Script Upgrade Failure after patching: RsFxFt.Dll::RsFxMgmtInitialize failed with error 0x80070002, and SQL would not come online. Here is the fix.