SQLTeam.com | Weblogs | Forums

New login unable to sign-on to SSMS

I created a new SQL login. Then i created a new user on database A and add this user to db_datareader role.

When i tried to signin via SSMS with this new login, i get the following:

Cannot connect to XXSERVERNAMEXX.

===================================

The SELECT permission was denied on the object 'dm_os_host_info', database 'mssqlsystemresource', schema 'sys'. (.Net SqlClient Data Provider)

2022-09-13_5-45-26

I read on different forums saying that it could be this login is a member of some deny roles, but i double checked it's not in any of those deny roles.

What else could it be? thanks