Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
Is he opening the connection by double-clicking an instance in the Registered Servers window or using the Connect drop-down / button in Object Browser? –  squillman May 14 '13 at 16:32
    
I'm not entirely sure at this moment - I've already asked him to try using the Connect drop-down to confirm that the Object Browser is connected as the same user. –  CJM May 15 '13 at 8:17
    
I've just spoken to my colleague - he tries to explicitly connect via Object Browser and it makes no difference. However, I've manage to connect into the same system with the same user from a different remote site without any problems at all. Confusing. –  CJM May 15 '13 at 8:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.