Solved

SQL Server Domain Group Member Trusted Login

Posted on 2011-03-03
7
399 Views
Last Modified: 2012-05-11
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
Comment
Question by:mystudent
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:dodge20
ID: 35031313
local will not work for a server name.

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

Author Comment

by:mystudent
ID: 35031380
Thanks, but I tried them all and still getting the same error.
0
 
LVL 11

Assisted Solution

by:dodge20
dodge20 earned 500 total points
ID: 35031431
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:mystudent
ID: 35031799
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
 
LVL 11

Assisted Solution

by:dodge20
dodge20 earned 500 total points
ID: 35036192
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
 

Accepted Solution

by:
mystudent earned 0 total points
ID: 35060053
The login was enabled.
The login was granted with connection permission.
It does not have the red down arrow by it.

Thanks,
0
 

Author Closing Comment

by:mystudent
ID: 35135907
Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2008 R2 - Execution Plan 3 57
SQL Transaction logs 8 27
Best Query To Insert One Year Calendar 6 45
Need help debbuging stored procedure 21 33
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now