?
Solved

SQL 2012 server login using windows authentication

Posted on 2014-03-27
8
Medium Priority
?
59 Views
Last Modified: 2015-09-15
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
Comment
Question by:paullord
[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
  • 2
8 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39960560
What error do your get?  And can you confirm you are using Windows Authentication?
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 40047369
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
 

Author Comment

by:paullord
ID: 40966400
I've requested that this question be deleted for the following reason:

sdfgdfsg
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40966396
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40966401
And it would have helped if I had actually re-opened the question.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40975432
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
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 40976559
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

800 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