SQL Server Express Management Studio - Add Login uses incorrect domain name for Windows domain group RRS feed

  • Question

  • Using SQL Server Management Studio Express Management Studio, when trying to add a Windows domain group login (i.e. ABC\DomainGroupName, SSMS correctly finds the domain group, but when you click OK, it replaces the domain name with AD\DomainGroupName. This domain is invalid. If you click OK, it says the group is invalid, which I would expect. If you manually replace AD with ABC and click OK, it also says this is not a valid group. If you go through the Windows OS, you can successfully add ABC\DomainGroupName as a local user. The machine has been reimaged and SQL Server Express reinstalled with the same result. Seven other machines have had this installed and it works with no problem.
    Thursday, November 14, 2019 7:17 PM

All replies