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)
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