Link to home
Create AccountLog in
Avatar of PDSWSS
PDSWSS

asked on

Why are my users not able to log into SQL Server 2008 R2?

I have had SQL Server 2008 R2 Set up on Windows Server 2008 for 3 -4 years.
I can log in everytime.
I set up a new user in Active Directory, he is able to RDP to the desktop
but when he tries to log into SQL Server he gets the attached error.
I set up a mock account to test and that test user gets the same error.

I gave both users  Owner permissions in SQL Server Security for the database.

Please advise.  Thanks,
sqlerror.png
ASKER CERTIFIED SOLUTION
Avatar of Matthew Kelly
Matthew Kelly
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of PDSWSS
PDSWSS

ASKER

Thank you very much.  I was not adding the users to the Server Security Folder.
You just saved me a lot more frustration.
Avatar of PDSWSS

ASKER

Perfect answer.