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 Management Studio – Taking DB Offline Made Easier
A train ride with my family got me looking at familiar things with fresh eyes, like how SSMS now makes taking a database Offline easier. Here is how.
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.
Database Scoped Configurations Changed From Their Defaults
One column in sys.database_scoped_configurations finds every setting that differs from its default. I show how to use it, and where it goes blind.
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.