Post reply

SQL Server Firewall Blocking replication even with Port 1433 allowed

  • May 31, 2018 at 6:33 am

    #1992455

    Maybe failing on the snapshot bit which uses different ports

    https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2017

    Replication connections to SQL Server use the typical regular Database Engine ports (TCP port 1433 for the default instance, etc.)

    Web synchronization and FTP/UNC access for replication snapshot require additional ports to be opened on the firewall. To transfer initial data and schema from one location to another, replication can use FTP (TCP port 21), or sync over HTTP (TCP port 80) or File Sharing. File sharing uses UDP port 137 and 138, and TCP port 139 if it using NetBIOS. File Sharing uses TCP port 445.

    Or if it is a named instance it may be using a different port.

    Does your firewall log show which ports were blocked or which ports the replication process was trying to use?

  • May 31, 2018 at 6:45 am

    #1992458

    The only port request showing on my firewall log is 1433

  • May 31, 2018 at 7:58 am

    #1992473

    OK, I figured it out eventually - Port 137 has to be enabled on Server 2

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply