connectivity in sql server with two diff public ip address

I 've two machines (Linux Servers) with firewall installed at two
geographical locations. Now I want to make replication of data using
sqlserver2000 from two other machines which are behind the two servers . Both
of them have have private IP address and they can access the internet
through the firewall . Now I have enabled the ports 1433 on both sides and
had given the IP address of the receiving machine at the sending machine
(Public IP at the network client -alias TCP/IP protocal) and vice versa.
Proper mapping of IP (public to private is done ) at the two servers.
But still I 'm getting the message, Failed to register the Sql Server
Pl help
Soumen,
you'll need to register an alias. Have a look at this article:
http://support.microsoft.com/?id=321822
(these may also be of interest
http://www.microsoft.com/resources/d...rt5/sqc07.mspx
http://support.microsoft.com/default...32&Product=sql)
HTH,
Paul Ibison
|||Did you define these two servers using Client Network Utiltity?
If you did, you can then create ODBC DSN's to them and test general
connectivity, or merely register these SQL Server as enabled Subscribers, or
register them in EM.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Soumen ( India)" <SoumenIndia@.discussions.microsoft.com> wrote in message
news:57461CAD-F259-4D49-8710-7217F7AFFE43@.microsoft.com...
> I 've two machines (Linux Servers) with firewall installed at two
> geographical locations. Now I want to make replication of data using
> sqlserver2000 from two other machines which are behind the two servers .
Both
> of them have have private IP address and they can access the internet
> through the firewall . Now I have enabled the ports 1433 on both sides and
> had given the IP address of the receiving machine at the sending machine
> (Public IP at the network client -alias TCP/IP protocal) and vice versa.
> Proper mapping of IP (public to private is done ) at the two servers.
> But still I 'm getting the message, Failed to register the Sql Server
> Pl help