SQL Server 2005 Replication on own Vlan

• glugingboulder

  SSCommitted

  Points: 1832

  More actions

  October 20, 2010 at 9:06 pm

  #230654

  Hi All,

  Trying to setup replication between clusters running SQL server 2005 which have 3 VLANS

  PROD

  MGMT

  BACKUP

  I want to send replicated data down the PROD LAN, SQL keeps configuring replication on the MGMT LAN

  Default route is MGMT is there anyway to get it running on PROD, without changing the routing?

  I have tried a creating alias mapped to the PROD LAN, host file references, i can see SQL using PROD during the configuration but when it delivers commands it uses MGMT i used netstat to view the connections, how does the replication internals resolve the virtualserver\instance name?.

  Is this possible? seems like a practical thing to do

• Iulian -207023

  SSCertifiable

  Points: 7510

  More actions

  October 23, 2010 at 6:36 am

  #1241272

  Hi,

  Reading this article it does not look very practical to me, but this depends on your needs.

  Here is a step by step guide on how to do it on a test environment.

  Good luck!

  Iulian