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.
SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
Joining a database to an availability group failed with Msg 35250: the connection to the Primary Replica is not active. Here is why and how to fix it.
Msg 15153: xp_cmdshell Proxy Account Cannot Be Retrieved
Msg 15153 is the second error a non-sysadmin user hits when running xp_cmdshell. A retail team with about 1,500 databases saw it right after Msg 229. A proxy account plus an EXECUTE grant fixed it.
Visual Studio 2010 Shell Error During SQL Server Patching: Missing Package
A Visual Studio 2010 Shell error interrupted a SQL Server patch in a 2017 case. The setup screen named the component, but the component log named the missing package. This post shows how to read the logs, decode the Windows Installer error and match the package before any repair.
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.
SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created
An old client met me at the airport with an edition upgrade error: Invoke or BeginInvoke cannot be called on a control. Here is the workaround.
SQL SERVER – My Thoughts – Autogrow of File ‘SQLAuth_Log’ in Database ‘SQLAuth’ was Cancelled by User or Timed Out After 30020 Milliseconds
Seeing ‘Autogrow of file was cancelled by user or timed out after 30020 milliseconds’ in the ERRORLOG? What it means, why it happens and what to do.