Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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