Retrieving data from remote MSDE server

• beath

  SSCrazy

  Points: 2939

  More actions

  June 17, 2003 at 10:03 am

  #160383

  I'm having some trouble retrieving data from a remote MSDE server using the syntax

  select * from server.database.dbo.table

  It is returning "SQL server does not exist or access denied"

  It is only failing from 1 specific server which happens to be the one I need to set it up on! If I try from one of my other ones and set the linked server up there it works fine. All are running SQL7 and should have identical setups.

  Any ideas?

  Thanks

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  June 17, 2003 at 10:18 am

  #461777

  Run sp_helpserver to see if it is a linked server, if is not, run sp_addlinkedserver, sp_addlinkedsrvlogin and

  sp_serveroption with the 'data access' parameter set to true.

  Check in bol for all the parameters needed.