Login failed for user even though it has read access
Verify if your user has permision to connect to database Engine. 
Right click on Logins -> Properties -> Status. 

Or grant CONNECT for user. 

CREATE LOGIN [mydomain\mygroup] FROM WINDOWS;
GRANT CONNECT SQL TO [mydomain\mygroup]