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.
You just saved me a lot more frustration.