Solved

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

Posted on 2009-07-06
3
182 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
  • 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Last week, our Skyport webinar on “How to secure your Active Directory” (https://www.experts-exchange.com/videos/5810/Webinar-Is-Your-Active-Directory-as-Secure-as-You-Think.html?cid=Gene_Skyport) provided 218 attendees with a step-by-step guide for…
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 transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

832 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