Home > SQL Server, T-SQL, Uncategorized > Grant Connect SQL Server – TSQL

Grant Connect SQL Server – TSQL

The issue

You are having connection problems to the database and all the permissions look correct but you cannot login.
Fire up the SSMS and expand the Security tree at the individual database and you notice that your login is there but with a little red down arrow.

The Fix

You need to grant “Connect” to your user.

Assume your user is a domain account DOMAIN\username

use MyDatabase 
GO

Grant Connect to [DOMAIN\username];
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Categories: SQL Server, T-SQL, Uncategorized Tags:
  1. No comments yet.
  1. No trackbacks yet.