Problem:
Giving permissions to a database user in not take effect.
Posible couse:
The user is "disabled". the user is showing up as disabled - with a down reddish arrow.
Solution:
USE [DataBaseName]
GO
GRANT CONNECT TO [Username]
GO