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?