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

SQL 2012 server login using windows authentication

Hi-
I’ve added some active directory groups to security\logins in management studio. The groups have public and sysadmin roles enabled. Despite this, when I log into the windows server using one of the members of these groups I am unable to login to SQL.

Any suggestions?
0
paullord
Asked:
paullord
  • 4
  • 2
1 Solution
 
Anthony PerkinsCommented:
What error do your get?  And can you confirm you are using Windows Authentication?
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Are the groups you've added to SQL Server actually security groups, or are they "Distribution Groups" in Active Directory? SSMS will let you assign rights to either, but distribution groups can't be evaluated for security membership and the user won't appear to have any of the rights you'd expect. You need to ensure you're using a security group to assign your rights.

Assigning rights directly to a user in SQL Server should always work as expected - I don't believe there are any exceptions there.
0
 
paullordAuthor Commented:
I've requested that this question be deleted for the following reason:

sdfgdfsg
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Anthony PerkinsCommented:
Re-opening the question to allow the user to explain why they are requesting the thread be deleted (see here for more info How do I delete a question?
0
 
Anthony PerkinsCommented:
And it would have helped if I had actually re-opened the question.
0
 
Anthony PerkinsCommented:
I will defer to Ryan, but he made some valid points that I think should be kept in the knowledge base.  So I would suggest Accept http:#a40047369
0
 
Ryan McCauleyData and Analytics ManagerCommented:
I come across this issue commonly, so I think it would make sense to come up as a search result. It seems to trip people up (myself included, before I figured it out) pretty frequently.

That said, I'm also fine if the question is considered unresolved and deleted - so I'll defer back :)
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

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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