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.
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];