Hi Lucas,
First, this is actually great news regarding the SIDs. I have reviewed your screenshots, and I can confirm your environment is now safe from the "Identity Crisis":
PWGIRSQL1: SID ends in ...1738-500.
PWGIRSQL2: SID ends in ...2762-500.
PWGIRSQL3: SID ends in ...6669-500.
You have successfully achieved unique identities for all three nodes. The root cause of your original cluster failure is gone.
Now, regarding the installation hang on PWGIRSQL2, dont worry. This is a very common side effect of a fresh Sysprep or Domain Join. The Server Manager GUI often hangs because the background "Windows Modules Installer" service is either waiting on a generic Windows Update check (which might time out if the server has no internet) or is blocked by a pending reboot flag left over from the domain join.
To unstick the Installation:
- Force a Reboot Since the GUI is stuck, you cant cancel it gracefully.
Close the "Add Roles and Features Wizard" (use Task Manager to kill it if necessary).
Reboot PWGIRSQL2 immediately. This will clear the locked files and reset the TrustedInstaller service.
- Install via PowerShell: Once the server is back online, dont use the GUI Wizard, it hides the actual errors. Use PowerShell, which is faster and provides real-time feedback.
Open PowerShell as Administrator on PWGIRSQL2. Run the following command:
Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools
- What if it hangs again? If the PowerShell command hangs at "10%" or "24%", it means the server is trying to download source files from Windows Update and failing.
=> You need to mount the Windows Server ISO (the installation media) to the server (e.g., as drive D:).
Run the command specifying the local source:
Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools -Source D:\sources\sxs
Once the feature shows Success: True in PowerShell, you are ready to add the node to the cluster.
I hope you've found something useful here. If it helps you get more insight into the issue, it's appreciated to accept the answer then. Should you have more questions, feel free to leave a message. Have a nice day!
VP