The problem
You have a SQL Login created for your account usr_test
Everything appears fine, but you cannot connect.
When you look in the users section of your database, the user appears with a disabled icon? (little red down arrow)
The issue
Your user does not have “CONNECT” permission and therefore shows as disabled.
The solution
In SQL management studio, do the following;
- Connect to your SQL Server
- Switch to the database having the issues
Use MyDatabase GO
- Execute the following statement
Grant Connect to usr_test
Refresh the list of users and now the user looks normal and you can connect to the database