Linked Server Not showing all obejcts

• Thomas George-390542

  Old Hand

  Points: 318

  More actions

  May 23, 2008 at 7:26 am

  #154382

  Dear All,

  I am trying a linked server connection from SVR1 to SVR2

  SVR1: Win2000 server + MSSQL server SP1

  SVR2 :WinXP prof. + MSSQL server standard

  I am able to create linked server with name as SVR2. But only the master database objects are displayed.

  anly solution..?

  Please help

  thanks in advance

  Thomas George

• Piotr.Rodak

  SSCrazy Eights

  Points: 9376

  More actions

  May 23, 2008 at 7:33 am

  #819657

  Check permissions of the login linked server uses to connect to SVR2. Is it mapped to databases you need to access?

  Piotr

  ...and your only reply is slàinte mhath