none
Replication - Problem with Firewall

    Question



  • I am trying to set up replication using a push subscription from Server 1 (local) to Server 2 (remote). 

    I have created a firewall rule to allow port 1433 through and I have set Server 2 to listen on that port only on the VPN IP address. Server 2 is a default instance so dynamic ports should not be an issue; nevertheless, I have turned on SQL browser and have also allowed port 1434 UDP through the firewall.

    I have no problem connecting to Server 2 using SSMS and also when using the create subscription wizard, I can connect to Server 2 to select the target database. When the subscription job runs, however, it fails with a ‘cannot connect to subscriber’ error. I have tried impersonation and using a SQL login, same problem with both.

    This seems to be a firewall issue because when I temporarily turn off the firewall on Server 2, the job runs fine.

    I can’t see anything in the firewall log to tell me what the problem is, I can see the connection from Server 1 on port 1433 but it just shows action ALLOW and path as RECEIVE.

    Any suggestions as to what I need to do on the firewall?


    • Edited by mharran Thursday, May 31, 2018 1:00 PM Formatting
    Thursday, May 31, 2018 11:06 AM

Answers

All replies