Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-16 : 09:22:39
|
| Michael writes "I need to set up replication on SQL Server 2000 SP3, and would like to know what ports (other than 1433) need to be opened on the firewalls.I have the following configuration:Subscriber/distributor Database --> Firewall 1 --> T1 --> Firewall 2 --> Data Warehouse.I believe 1433 needs to open on Firewall 1, and then ports higher than 1024 need to be available in Firewall 2, but I have not been able to find anything to confirm this.Any help will be appreciated.Michael." |
|
|
mhbianc
Starting Member
2 Posts |
Posted - 2003-12-16 : 10:20:47
|
| Correction... The configuration is Publisher/distributor --> Firewall 1 --> T1 --> Firewall 2 --> Data Warehouse (Subscriber)Michael. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-16 : 19:57:13
|
| You only need to open the port that SQL Server is listening on. But don't use 1433! Reconfigure your SQL Server to listen on a different port.Tara |
|
|
|
mhbianc
Starting Member
2 Posts |
Posted - 2003-12-18 : 10:35:26
|
| Thanks for your reply. I'm assuming you say don't use 1433 because it's a well known port, and, if made available, could be a security risk. Are there other reasons?Thanks!Michael. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-18 : 12:16:04
|
| Security is the reason.Tara |
|
|
|
|
|
|
Replication ports on Firewall