Solved

SQL Server Domain Group Member Trusted Login

Posted on 2011-03-03
7
401 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

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, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

806 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