The AlwaysOn wizard failed while checking database file locations on the secondary replica, though the drives were correct. Here is the workaround.
SQL SERVER – AlwaysOn Wizard Error – The Endpoints Tab Lists at Least One Endpoint that Uses Only Windows Authentication
Setting up an availability group, a client hit an AlwaysOn Wizard Error: an endpoint uses only Windows Authentication. Here is why and how we got past it.
SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group
The AlwaysOn wizard said auto close is enabled, so the database can’t join an availability group. Here is why, and the settings to change first.
SQL SERVER – Add Node Error – Rule “SQL Server Database Services Feature State” Failed
Adding a second node to my SQL Server 2016 cluster failed the Database Services feature state rule. Here is the registry key behind this Add Node Error.
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
How do you assign Multiple Variables in a single T-SQL query? Here are three ways, from separate SET statements to my preferred one-line style.
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
After I broke a named instance in my lab, sqlservr.exe gave a startup error: your installation is either corrupt or has been tampered with. Here is the fix.
RDP Logoff Message: Please Wait for the System Event Notification Service
The RDP logoff message “Please wait for the System Event Notification Service” can have many causes. A client’s users hit it at logon and logoff, and a reboot was the only cure. Here is the SQL Server related cause and two workarounds.