Unable to initialize encryption can stop SQL Server before it accepts a connection, as it did on a SQL Server 2008 SP4 instance in 2017. This post reads the startup messages, corrects an old explanation about missing TLS registry keys and shows tested checks for the ERRORLOG, the certificate and the Schannel settings.
SQL SERVER – FIX : Error Msg 8672 – The MERGE Statement Attempted to UPDATE or DELETE the Same Row More Than Once
While preparing a demo I hit Msg 8672: the MERGE statement attempted to UPDATE or DELETE the same row more than once. Here is why and how to avoid it.
Print Status Messages Using RAISERROR WITH NOWAIT
To see progress while a long script runs, use RAISERROR WITH NOWAIT instead of PRINT. This post builds a progress loop, formats values with placeholders, and shows the percent sign trap that garbles a message. It also explains how severity decides whether a message stays inside a TRY block, and where the 2,047 character limit cuts a message.
SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)
SQL Server would not start after patching: Script Upgrade failed because ##MS_PolicyEventProcessingLogin## had been granted permissions. Here is the fix.
Specified Driver Is Invalid in SQL Server Setup: Error 0x84BB0001
The specified driver is invalid error stopped a SQL Server 2012 installation with code 0x84BB0001. The real clue sat in Detail.txt, in the performance counter files, and a fresh copy of the media fixed it. This post shows how to read the logs, check the counter files and confirm the media.
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration for SQL is Inaccessible or Invalid
After server hardening, SQL Browser would not start and the event log said the SQL configuration for SQL is inaccessible or invalid. Here is the fix.
Number of Cluster Nodes Error: Add Node Fails on Enterprise Edition
The number of cluster nodes error stopped a client from adding a second node, even on Enterprise edition. Detail.txt showed the edition as Invalid. The file setup uses to read the edition was missing from the Shared folder.