[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2012 server login using windows authentication

Posted on 2014-03-27
8
Medium Priority
?
63 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
  • 4
  • 2
7 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

872 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