Solved

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

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

Save on storage to protect fatherhood memories

You're the dad who has everything. This Father's Day, make sure your family memories are protected. My Passport Ultra has automatic backup and password protection to keep your cherished photos and videos safe. With up to 3TB, you have plenty of room to hold the adventures ahead.

Question has a verified solution.

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

SHARE your personal details only on a NEED to basis. Take CHARGE and SECURE your IDENTITY. How do I then PROTECT myself and stay in charge of my own Personal details (and) - MY own WAY...
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now