How to link 2 sql server 2000 via internet ?

How to link 2 sql server 2000 via internet ?

• hafizsohaib

  With SQL server 2000 you would have to look at something like linked servers or replication over the internet, in SQL 2005 I would use Service Broker but you need a non express SKU as part of the conversation for that to work.
  
  

• tmn

  I wouldnt put sql servers directly on the internet, at least without changing the port and possibly encrypting the connections. Look at the SQL Server Configuration Utility. Use the IP Address:port in the connection string. Still, I would hesitate at doing this.

  Depending on the deployment topology, I would do one of the following:

  1. Create a VPN connection and link server B to A, tunnelling (is that the right term ) on the VPN. The vpn will make it appear as if they are on the same LAN (see books online for linked servers)
  2. Define a web service on B's domain that performs the insert. Create a .NET/ActiveX client object that is insantiated in A's trigger to interface the web service.
  3. Define a Loosely Coupled Event (COM+ event) that is generated in A's trigger that an app in B's domain would subscribe to.

  What is your topology like Do you have RAS set up on both domains use scenario 1. scenario 3 requires a little more config though if B unsubscribes, A wouldn't know it. Scenario 2 requires the most config (except scenario 1 with configuring RAS) and is reliable.

  None of the above scenarios is really that difficult once you have done it. Just doing it the first time there will be learning curve. But thats the nature of computing, isnt it

  as far as sql versions here is a matrix

  Version A <links- Version B
  2000<-2000 2000<-2005 2005<-2000 2005<-2005
  Scenario 1 YES NO YES YES
  Scenario 2 YES YES YES YES
  Scenario 3 YES YES YES YES

  Note, scenario 1 also applies to open internet port visibility.

  
  
  
• How to link 2 sql server 2000 via internet ?