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

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?
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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.

jdanaAuthor Commented:
Raja Jegan RSQL Server DBA & ArchitectCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.