Replication across different networks

Hi all,
I would be grateful if you all could help.
I have one server acting as publisher and distributor in one data center
and the other one center acting as subscriber in another data center.
I would like to perform replication between these two computers.
In order to perform replication, these two computers must be in the same
domain.
Are there any feasible solutions that i can perform replication betwen
these two computers across different networks?
Thx so much!!!
On 2004-12-06, Eric <Eric@.discussions.microsoft.com> wrote:
> Hi all,
> I would be grateful if you all could help.
> I have one server acting as publisher and distributor in one data center
> and the other one center acting as subscriber in another data center.
> I would like to perform replication between these two computers.
> In order to perform replication, these two computers must be in the same
> domain.
> Are there any feasible solutions that i can perform replication betwen
> these two computers across different networks?
If it's all TCP/IP, you don't have a problem. You don't have to have your
servers in same domain. I'm even doing replication over internet trough SSH
tunneling, via two unix machines, it works perfectly fine.
What you need to do is make sure you have TCP/IP connection to the remote
machine. You could test this by issuing this from command prompt:
telnet <remote.machine.ip> 1043
If you get connected (the screen goes blank), it means you're ok. If you get
'connection refused', 'connection closed by remote host', 'no route to
host', or similair, or you just kepp hanging at 'connecting...', it means
you don't have connection.
Once you established connection you should add the clients server ip to the
SQL Client Network utility with apropriate alias. Then you use that alias in
EM to establish replication between these two servers. Replication scripts
will use IP address stored in the client network utility when translating
the alias name you specified.
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr