Database Mail with Gmail failed: the SMTP server requires a secure connection or the client was not authenticated, 5.5.1. Here is how to fix it.
SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER
Seeing many BACKGROUND threads with command VDI_CLIENT_WORKER? Here is what the VDI_CLIENT_WORKER and VDI_CLIENT_OTHER wait types mean.
SQL SERVER – Event ID: 1135 – Cluster node ‘NodeName’ was Removed From the Active Failover Cluster Membership
Event ID 1135 says a cluster node was removed from the active failover cluster membership. Here is what a customer’s AlwaysOn setup taught me about it.
SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!
A client’s SQL Resource would not come online on either cluster node. The ERRORLOG showed a very slow recovery of a huge master database. Here is the fix.
SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin
Moving logins with sp_help_revlogin, I hit Msg 15419: supplied parameter sid should be binary(16). Here is what causes it and how to fix the script.
SQL SERVER – Transfer Logins Error: Msg 15021: Invalid Value Given for Parameter Password
Moving logins with sp_help_revlogin failed with Msg 15021: invalid value given for parameter PASSWORD. Here is what was wrong with the hashed password.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 3
Part 3: one more reason SQL Server setup can fail the MSCS cluster verification errors rule during install or AddNode, as seen at a client, and the fix.