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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect answer.
ASKER
You just saved me a lot more frustration.