asked on

SQL Server Domain Group Member Trusted Login

Hi,

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?

Thanks.

dodge20

local will not work for a server name.

Use either the actual machine name, localhost or a dot (.)

mystudent

ASKER

Thanks, but I tried them all and still getting the same error.

SOLUTION

dodge20

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mystudent

ASKER

Thanks,

Yes, The shared memory was enabled.
No. It is not a named instance
Yes, It has default database and has db_owner role for the default database
Yes. I think so. The domain group is also the member of local admininstrators group and is able to perform local admin tasks.

SOLUTION

dodge20

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

mystudent

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mystudent

ASKER

Thanks.