Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I want to have windows authentication login to SQL 2008, the problem I'm facing is that I want to have a User group to be a login, which i succeed in setting up a Login for the SQL database and a user for the database. But when I login with windows authentication it fails.

Example: I added a Login with windows authentication MyDomain\SqlUsers

MyDomain\Robert is in the MyDomain\SqlUsers User Group.

I login in(while logged in as MyDomain\Robert) to Sql managementstudio and it fails.

What am I doing wrong?

share|improve this question
    
More details on the error would potentially help in solving the problem quicker. –  Diago Jul 14 '09 at 8:01
add comment

3 Answers

up vote 1 down vote accepted

After you create the login you need to add the login to the databases.

What's the error message you get when logging in with MyDomain\Robert?

share|improve this answer
add comment

Did you set, in the Status tab of the Login properties, the 'Grant Permission' checkbox?

share|improve this answer
add comment

In the Login Properties there's a section titled "User mapping". You need to use this to grant your group access to the database(s) and specify what access they have.

Using a Windows group does work as I use this myself (along with millions of other SQL dbas :-)

JR

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.