Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.
Script Upgrade Mode in SQL Server: Login Failed (Error 18401) While Deleting a Collection Set
Script upgrade mode can reject logins for a while after a SQL Server update, and in this 2017 client case the startup log stopped at a collection set cleanup. This post shows how to read error 18401, check whether the upgrade still moves and size the msdb logging tables with tested queries.
Xpstar.dll Could Not Load in SQL Server: Error 17750 and Reason 126
An xpstar.dll loading error can name a DLL that is already present, because error 17750 with reason 126 usually points at a dependency. This post reads both parts of the error, checks the file, the VC++ runtimes and the loaded modules with tested commands, and explains why copying DLLs between machines is not a repair.
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 – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
A script upgrade failure left SQL Server down with RsFxFt.Dll error 0x80070002 and error 5597. Tested on SQL Server 2025: the FILESTREAM cause.