SQL Server Domain Group Member Trusted Login
Posted on 2011-03-03
We have a domain user domainA/user1 and it is one of members of domainA/groupA. DBA created a trusted login for the domain group domainA/groupA in the SQL server instance. However, when domainA/user1 tries to login to the sql server instance using server name = local and Authentication = Window Authentication, he got a login error saying Failed login domainA/user1 with 18456.
What could be missed or the problems?