A clustered instance would not start: Error 26014, unable to load user-specified certificate. What the ERRORLOG showed and how we got SQL Server running again.
SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use
After patching, database mirroring stopped and the ERRORLOG showed Error 26023: TCP Port is already in use on 5022. Here is how we found the cause and fixed it.
SQL SERVER – Errors When Disk Space is the Reason
When disk space runs out, SQL Server logs errors like 1101 and 1105, often during recovery. A roundup of the common messages and what each one tells you.
SQL SERVER – FIX Error – Cluster Network Name showing NETBIOS status as “The system cannot find the file specified”
A Cluster Network Name would not come online and showed NETBIOS status ‘The system cannot find the file specified’. Which log to check and how we fixed it.
SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())
A connection error on a named instance that works by port but not by name. What SQL Browser answers on UDP 1434, and why local tests prove nothing.
SQL SERVER – Error – Disallowing page allocations for database ‘DB’ due to insufficient memory in the resource pool
My SQL Server 2016 error log kept saying ‘Disallowing page allocations for database due to insufficient memory in the resource pool’. What it means and the fix.
SQL SERVER – Rule “Windows Management Instrumentation (WMI) Service” failed
Upgrading a two-node cluster from SQL 2008 R2 to 2014, the rule ‘Windows Management Instrumentation (WMI) Service’ failed. Here is how we fixed it.