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.
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.
SQL SERVER – Message: “Please wait for the System Event Notification Service” When Trying to Logoff from RDP Session
Users logging off RDP saw “Please wait for the System Event Notification Service” until a reboot. Here is how SSMS and the Visual Studio shell were involved.
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.