Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

does sql replication require additonal ports open through a firewall?

Posted on 2004-09-03
1
Medium Priority
?
244 Views
Last Modified: 2008-02-01
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
Comment
Question by:pjordanna
1 Comment
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 2000 total points
ID: 11972638
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question