Port Usage

• stevelang

  Valued Member

  Points: 67

  More actions

  August 27, 2001 at 3:17 am

  #77232

  I am attempting to import data from one SQL Server to another by linking both SQL Servers together and running a query using the 4 part SQL object name.

  The SQL Servers are situated over separated networks, this being 2 separated VLANS. For security reasons I wish only to connect over a single port (say 1433).

  When I try to link the servers together I get message saying that the Distributed Transaction Coordinator is not available. This is deliberately as I do not want to open up the RPC ports.

  Is there any solution to this problem?

  Steve