Home > SQL Server > SQL Server Enable User

SQL Server Enable User

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)
usr_test_disabled

The issue

Your user does not have “CONNECT” permission and therefore shows as disabled.

The solution

In SQL management studio, do the following;

  1. Connect to your SQL Server
  2. Switch to the database having the issues
    Use MyDatabase
    GO
    
  3. Execute the following statement
    Grant Connect to usr_test
    
  4. Refresh the list of users and now the user looks normal and you can connect to the database

    VN:F [1.9.22_1171]
    Rating: 0.0/10 (0 votes cast)
Categories: SQL Server Tags:
  1. No comments yet.
  1. No trackbacks yet.