If you look at Users under Security at a database in SSMS and there is a little red X by the user that means that the user does not have "connect abilities" for the database.

The SQL command to give someone back their access is:

grant connect to [jimAcosta]