How to query data from two differnt site and different domain

• solomon.jernas

  Hall of Fame

  Points: 3680

  More actions

  November 28, 2011 at 12:17 am

  #390960

  I have given deatils..

  1) We have two sites Silverton and Port Elizabeth, the data from Silverton needs to be read and reports need to be generated for Silverton site from Port Elizabeth. Is it possible to link both the servers?

  2) The server in Silverton is behind a firewall and hence we will not be able to access the server the usual way. We have to get to the firewall team to open up ports are provide us with specific access to the server.

  3) The Server at Silverton is running SQL Server 2008 R2 Standard edition.

  4) The server at Port Elizabeth is running SQL Server 2005 Standard edition

  Please give your suggestion for the above:

  Thanks

  Jerry

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 28, 2011 at 2:46 am

  #1413293

  Duplicate post. Replies here please.

  -- Gianluca Sartori