Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-07-06
3
Medium Priority
?
193 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 1000 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

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Question has a verified solution.

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

Here's a look at newsworthy articles and community happenings during the last month.
A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

609 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