[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL Server Domain Group Member Trusted Login

Posted on 2011-03-03
7
Medium Priority
?
407 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

650 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