The AlwaysOn wizard failed while checking database file locations on the secondary replica, though the drives were correct. Here is the workaround.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.