Skip to main content
replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).

What I've gathered so far, is that I need for the log files to be copied to the secondary, I need CIFS ports opened:

ports 135,137,138,139,445

Per this question, I need to also make sure the SQL Server is NOT set to dynamic:

http://stackoverflow.com/a/10540007/1192939https://stackoverflow.com/a/10540007/1192939

and it seems, all that's required beyond that would be for 1433 to be available:

http://sqlmag.com/sql-server/sql-server-tcp-and-udp-ports

Am I leaving out anything?

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).

What I've gathered so far, is that I need for the log files to be copied to the secondary, I need CIFS ports opened:

ports 135,137,138,139,445

Per this question, I need to also make sure the SQL Server is NOT set to dynamic:

http://stackoverflow.com/a/10540007/1192939

and it seems, all that's required beyond that would be for 1433 to be available:

http://sqlmag.com/sql-server/sql-server-tcp-and-udp-ports

Am I leaving out anything?

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).

What I've gathered so far, is that I need for the log files to be copied to the secondary, I need CIFS ports opened:

ports 135,137,138,139,445

Per this question, I need to also make sure the SQL Server is NOT set to dynamic:

https://stackoverflow.com/a/10540007/1192939

and it seems, all that's required beyond that would be for 1433 to be available:

http://sqlmag.com/sql-server/sql-server-tcp-and-udp-ports

Am I leaving out anything?

edited title
Link
marc_s
  • 9k
  • 6
  • 45
  • 52

What Open Ports are Necessary for MSSQLSQL Server Log Shipping to Secondary on the Internet

Source Link
Kendor
  • 159
  • 7

What Open Ports are Necessary for MSSQL Log Shipping to Secondary on the Internet

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).

What I've gathered so far, is that I need for the log files to be copied to the secondary, I need CIFS ports opened:

ports 135,137,138,139,445

Per this question, I need to also make sure the SQL Server is NOT set to dynamic:

http://stackoverflow.com/a/10540007/1192939

and it seems, all that's required beyond that would be for 1433 to be available:

http://sqlmag.com/sql-server/sql-server-tcp-and-udp-ports

Am I leaving out anything?