Solved

SQL Server Express Won't Take <domain>\Domain Users Group as a Login

Posted on 2009-07-06
3
184 Views
Last Modified: 2013-12-04
I just tried to add the <domain>\Domain Users group as a SQL Server Login.  (I took a crack at <domain>\Everyone as well.  No luck with that group either.)  The instance of SQL Server lives on the office domain controller.  I was able to accomplish what I needed by adding BUILTIN\Users as a SQL Server Login.  (BUILTIN\Users contains <doman>\Domain Users.)  But the question still remains, why didn't <domain>\Domain Users or <domain>\Everyone work?  Does the restriction stem from SQL Server Express?  The fact that instance of SQL Server resides on the domain controller?  Something else?
0
Comment
Question by:jdana
[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
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 24785960
Hope you have either Vista or Windows Server 2008 with you.

In both the cases, you need to elevate the user privileges so that those users would be able to connect to the machine.

Kindly follow this one out to resolve this issue.

http://msdn.microsoft.com/en-us/library/bb326612(SQL.90).aspx
0
 

Author Closing Comment

by:jdana
ID: 31600194
Thanks
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24786121
Welcome
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

726 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