no access to Linked Servers

  • Hi everyone. I have a client laptop running SSMS to access SQL 2005 instances on our intranet. The odd thing about this client is there is no expansion 'plus' sign next to the Linked Servers. It doesn't matter what user logs into this client, the results are the same... no expansion of the linked servers. The same users can log into a different client and expand the linked server and see the remote catalogs. The clients have identical OS and service packs. Any ideas?

    SQL 05 Standard SP2

  • Is the browser service running? ("SQL Server Browser")

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thanks for responding GSquared. On the server box...yes. On the clients no. But the user can log into a different client and access catalogs thru the linked servers. BTW, is there a client browser service that should be running on the clients?

  • Verify the version of the client on that laptop and compare to the version on the other clients.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply