A student could not connect with the Dedicated Administrator Connection (DAC) after my class. Here is the port error he saw and how to fix it.
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. There is No Compatible Encryption Algorithm. State 22
Moving from database mirroring to an AlwaysOn AG failed with a handshake error: no compatible encryption algorithm. Comparing the endpoints showed why.
SQL SERVER – Mirroring Error: Connection handshake failed. Could not send a handshake message because the connection was closed by peer. State 26
A mirroring error, connection handshake failed, State 26. The checks I once asked readers for, run on SQL Server 2025 on a real endpoint.
Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119
Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
SQL SERVER – Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
A friend using certificates on workgroup machines hit a database mirroring error: Connection Handshake Failed. Here is how I tracked it down in the ERRORLOG.
SQL SERVER – Installation Error – [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Patching SQL Server 2005 on a cluster failed with ‘Data source name not found and no default driver specified’. What caused it for a reader and the fix.