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
Microsoft SQL Server 2008Windows Server 2008
Last Comment
PDSWSS
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect answer.
You just saved me a lot more frustration.