Server not showing joined to AG but primary still shows it as joined.
Server is still added to the availability group if you view the primary.
When browsing to the AlwaysOn High Availability from the affected server, it shows up blank
The affected server is still in the failover cluster
The affected server still has the checkbox for being added to the Availability Group (SSCM)
Rebooted the affected server.
Failed over Cluster resource to simulate a restart, no change.
Steps to fix –
- Stop SQL Services on the affected node.
- From the Primary Replica, remove the affected node from the AlwaysOn Availability Group.
- Clear the checkbox for Enable AlwaysOn Availability Groups through SSCM, hit apply.
- Check the checkbox for Enable AlwaysOn Availability Groups through SSCM, hit apply.
- Start SQL services on the affected node.
- At this point, any databases that were in the availability group will need to have T-log restores, or, in my case, need to be dropped and manually re-seeded.
- Once all databases are seeded, verify the health of the AlwaysOn Availability Group via the dashboard.
While trying to install a service pack on one of my systems, I ran into a server that kept exiting setup stating it was missing files from C:\Windows\Installer. This is unfortunate as some people will actually clear out the C:\Windows\Installer directory trying to free up space. Luckily, Microsoft has a few tools for fixing this issue. You can either use the FixMissingMSI tool, or the FindSQLInstall.vbs script. I prefer the FixMissingMSI tool as sometimes getting the approval to run a .vbs script can be difficult to obtain. Both tools can be found here:
Update: Several co-workers have asked me if there is anything that is safe to remove from this directory. The answer is that it depends. If you see a ton of .tmp files and they each 133MB and there’s a hundred of them, by all means delete them. Typically .tmp files are caused by a failed download from the updates server. Remove these without a problem, then download the actual update file that is being installed and install it manually. This should clear up any issues like that.