SQL Create Login Failure (Microsoft SQL Server, Error: 15401)

One of our folks was setting up his lab using Virtual Machines and he finished almost everything including setting up DC, Windows Cluster etc. but when he was trying to create an account in SQL Server, he was getting bellow error:

After almost a day’s investment, he came back asking what’s next and how to resolve it. He had already followed https://support.microsoft.com/kb/324321 but still no luck as none of the scenarios mentioned in KB was matching.

We did further analysis and found few loopholes in the setup such as he did not SYSPREP the base machine Well now what? I really can’t suggest him to run SYSPREP again on base machine and re-setup his lab from the scratch.

We looked for NewSID but https://blogs.technet.com/b/markrussinovich/archive/2009/11/03/3291024.aspx says NewSID is already retired and not available for download

We had no other option except going for something which is not supported. We looked for archived tools and finally could find NewSID 4.10. We downloaded the tool and ran it on the VM. It gave an option for random SID. We selected that option and allowed the wizard to complete.

Box restarted and the great news, SQL allowed us to create accounts. We realized that this was happening because Duplicate SID of local administrator account which was conflicting with Domain Admin account SID.

Note: One of his standalone machine ended up with BSOD and there he did not have any other option except going for setup again. But 80% of his lab survived..