NEOROUTER FIREWALL PORTS WINDOWSI 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. RPC dynamic port allocation is used by server applications and remote administration applications, such as Dynamic Host Configuration Protocol (DHCP) Manager, Windows Internet Name Service (WINS) Manager, and so on. This seems to be a firewall issue because when I temporarily turn off the firewall on Server 2, the job runs fine. I have tried impersonation and using a SQL login, same problem with both. When the subscription job runs, however, it fails with a ‘cannot connect to subscriber’ error. 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. 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 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. I am trying to set up replication using a push subscription from Server 1 (local) to Server 2 (remote). They are not members of a domain, and connected over a VPN (using Neorouter). This opens the Availability Group Listener Properties dialog box.I have two servers, Server 1 and Server 2, both are stand-alone, Windows Server 2016 with SQL Server 2017 using default instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |