• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

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.

0
mystudent
Asked:
mystudent
  • 4
  • 3
3 Solutions
 
dodge20Commented:
local will not work for a server name.

Use either the actual machine name, localhost or a dot (.)
0
 
mystudentAuthor Commented:
Thanks, but I tried them all and still getting the same error.
0
 
dodge20Commented:
I am assuming you are logging in locally from the box since you tried to use the localhost as the server name.

A few other thoughts
-Is shared memory enabled in sql server configuration manager protocols?
-Is this a named instance? If so you need to specify the name of the instance as well as have the browser server started.
-Did your dba specify a default database and give access to that database?
- Has the AD change replicated out?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mystudentAuthor Commented:
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.
0
 
dodge20Commented:
Is the login disabled?
Does the user have connect permissions?
(Management studio shows a red down arrow by the login or user if this is the case - the user is under database level security).

Is there any more information you can give - either through sql's error log or windows event viewer?
0
 
mystudentAuthor Commented:
The login was enabled.
The login was granted with connection permission.
It does not have the red down arrow by it.

Thanks,
0
 
mystudentAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now