Linked server Problem

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  September 24, 2009 at 2:39 am

  #135428

  hi all

  i created a linked server in sqlserver 2005. i cant able to see the catalogs of that user using ssms 2005 . but if open in ssms2008, i can able to see all catalogs with same linked server name.

  can any one tell me how to resolve this issue in ssms 2005.

  Thanks

  Rock..

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 24, 2009 at 2:53 am

  #1057907

  rockingadmin (9/24/2009)

  ---

  hi all

  i created a linked server in sqlserver 2005. i cant able to see the catalogs of that user using ssms 2005 . but if open in ssms2008, i can able to see all catalogs with same linked server name.

  can any one tell me how to resolve this issue in ssms 2005.

  Thanks

  Rock..

  What security settings are setup in the linked server

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  September 24, 2009 at 3:24 am

  #1057914

  local login:: sysadmin user

  impersonate i used

  for a login not defined in the list above connections will,

  be made using this security context

  remote user (not a sysadmin)

  remote pass

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  October 4, 2009 at 11:50 pm

  #1061551

  any idea on this issue??

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  October 5, 2009 at 12:25 am

  #1061557

  actually i have migrated every thing from sqlserver 2005 standard to sqlserver 2005 developer edition.after that i created the linked server between sqlserver 2005 standard and sqlserver 2005 developer edition. it was executed sucessfully. but after that i can able to view all the catalogs in the linked server.

  is there any specific option is there for accessing the catalogs in linked server.But i can able to view those linked server using the ssms2008.

  what is the reason behind this??

  Thanks

  Rock..