?
Solved

SQL Server Domain Group Member Trusted Login

Posted on 2011-03-03
7
Medium Priority
?
408 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 2000 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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 2000 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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

850 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