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.
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
An LDAP query through a linked server worked in one domain but failed in another with Msg 7399 from the ADsDSOObject provider. Here is the fix.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
A client’s event log said the description for Event ID 18456 from source MSSQLSERVER cannot be found. Here is what it means and where to see the real error.