Transactional replication over the internet using a firewall 
Author Message
 Transactional replication over the internet using a firewall

Hi

I currently posted the below article and I have done as the response has
suggested.

I have made the following modifications to the subscriber -

    In client configuration -
      Added publisher_name and it's public access IP address
      Added publisher_Public_IP as a name with it's Public IP address
    Added a Hosts file with the publishers name
      ping publisher_name worked

The same error still occurs.

Any further help would be appreciated.

Martin Aldridge
Database Developer/Administrator
Acequote.com Ltd

****************************************
*PREVIOUS ARTICLE

Hi

I am currently getting the below error -

    "The remote server does not exist or has not been designated as a valid
Publisher. The step failed."

in job history on a pull subscription.

The SQL servers are configured as such -

      Publisher
            SQL 7.0, Win2k Advanced Server
            Private IP address (10.0.0.x)
            Anonymous publication with FTP and anonymous pull enabled
            This sits behind a firewall that maps a public IP address to it.
            Firewall enabled to let both SQL port and FTP Port through
            FTP setup and security configured
            Have setup client Network so computer name has public IP of subscriber

      Subscriber
            SQL 7.0, NT 4
            Public IP address
            Anonymous Pull subscription from publisher (successfully setup)
            Set User login as sa
            Set FTP to Public IP and port and user on Firewall at publisher
            Can successfully FTP across to publisher
            Can successfully connect to SQL on publisher
            Have setup client Network so computer name has public IP of publisher

We have had this successfully working the other way around where the sub is
behind a proxying firewall, but can't get it so as the pub is behind a proxying
firewall. Ideally we want both pub and sub behind their own proxying firewall.

Any ideas

Many thanks

Martin Aldridge
Database Developer/Administrator
Acequote.com Ltd

Re: Internet replication and firewalls  
From: TSVK
Date Posted: 5/10/2001 1:52:00 PM

The problem is that the proxy name/IP with which the subscriber is trying to
refer publisher (because of proxying) does not exist on the publisher in
sysservers. The publisher knows that itself is a publisher only by its own

himself can be referred by others by proxy name).   The solution would
create a client side alias on subscriber machine which would connect to
publisher with publisher's true name but directed to the proxy port.

For eg. If publisher is called server A and subscriber is server B. Create
an alias on server B which has aliasname - serverA but refers to proxied IP
address/port. Use cliconfg.exe to create alias or you could use lmhosts
file



Sat, 01 Nov 2003 01:06:32 GMT
 Transactional replication over the internet using a firewall


publisher.master.dbo.sysservers is the actual publisher srvid.

Also check that sp_helpdistpublisher on distributor returns the same name.

If this doesnt help you  I suggest you contact microsoft support for more
help.


Hi

I currently posted the below article and I have done as the response has
suggested.

I have made the following modifications to the subscriber -

    In client configuration -
      Added publisher_name and it's public access IP address
      Added publisher_Public_IP as a name with it's Public IP address
    Added a Hosts file with the publishers name
      ping publisher_name worked

The same error still occurs.

Any further help would be appreciated.

Martin Aldridge
Database Developer/Administrator
Acequote.com Ltd

****************************************
*PREVIOUS ARTICLE

Hi

I am currently getting the below error -

    "The remote server does not exist or has not been designated as a valid
Publisher. The step failed."

in job history on a pull subscription.

The SQL servers are configured as such -

      Publisher
            SQL 7.0, Win2k Advanced Server
            Private IP address (10.0.0.x)
            Anonymous publication with FTP and anonymous pull enabled
            This sits behind a firewall that maps a public IP address to it.
            Firewall enabled to let both SQL port and FTP Port through
            FTP setup and security configured
            Have setup client Network so computer name has public IP of
subscriber

      Subscriber
            SQL 7.0, NT 4
            Public IP address
            Anonymous Pull subscription from publisher (successfully setup)
            Set User login as sa
            Set FTP to Public IP and port and user on Firewall at publisher
            Can successfully FTP across to publisher
            Can successfully connect to SQL on publisher
            Have setup client Network so computer name has public IP of
publisher

We have had this successfully working the other way around where the sub is
behind a proxying firewall, but can't get it so as the pub is behind a
proxying
firewall. Ideally we want both pub and sub behind their own proxying
firewall.

Any ideas

Many thanks

Martin Aldridge
Database Developer/Administrator
Acequote.com Ltd

Re: Internet replication and firewalls
From: TSVK
Date Posted: 5/10/2001 1:52:00 PM

The problem is that the proxy name/IP with which the subscriber is trying to
refer publisher (because of proxying) does not exist on the publisher in
sysservers. The publisher knows that itself is a publisher only by its own

himself can be referred by others by proxy name).   The solution would
create a client side alias on subscriber machine which would connect to
publisher with publisher's true name but directed to the proxy port.

For eg. If publisher is called server A and subscriber is server B. Create
an alias on server B which has aliasname - serverA but refers to proxied IP
address/port. Use cliconfg.exe to create alias or you could use lmhosts
file



Sat, 01 Nov 2003 02:41:37 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL7 transactional replication over Internet via FTP

2. Encryption with Internet Transactional Replication

3. Transactional replication over the internet

4. Merge replication over Internet and Firewall

5. Setup Problem - Transactional Replication over the Internet

6. IS TRANSACTIONAL REPLICATION RELIABLE OVER THE INTERNET?

7. Replication through firewall using ftp

8. Replication through a firewall using ftp

9. Replication using FTP within firewall

10. replication over a firewall and using tcp/ip

11. transactional replication using ftp

12. transactional replication using vpn to vpn


 
Powered by phpBB® Forum Software