A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the Object Browser for one database, he can't view them in another.
The login I provided was added to the db_owner role for both databases, and so I expected access to be the same.
If I login locally, from a neighbouring server using the same login, I can see everything fine. An obvious difference here is that I am inside the same network and am accessing the server via NETBIOS name. [It occurs to me that I should try using IP address, as he does]
I've tried creating an alternate user with the same permission - no improvement, as expected.
However, if he creates a new query window, he can access both databases and run queries against them.
Can anyone suggest why he might be struggling to see the expected objects in SSMS?
0 Answers