[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

does sql replication require additonal ports open through a firewall?

hi there,

I have a remote sql box that i'm trying to replicate with over a vpn and through a firewall.

I can get to it with pings and enterprise manager, but when i try to create a pull subscription I can't see the package that I've created in the wizard - even though I can see it in enterprise manager....

I'm wondering if there more ports that need to be opened for this to work...

Any suggestions or other thoughts gratefully received...
0
pjordanna
Asked:
pjordanna
1 Solution
 
jdlambert1Commented:
By default, SQL Server uses port 1433 for most things on TCP/IP, if there's only one instance installed. You can set it to whatever you want to with the Network Utility, but both sides of the replication process need to match.

See also: http://www.winnetmag.com/SQLServer/Article/ArticleID/38444/38444.html
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now