HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What port is used by SQL Server to write backups to a remote server?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
backupswhatsqlusedwriteportserverremote

Problem

I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers suggest that they can open a port for me. Hence the question: What port is used by SQL Server to write backups to a remote server?

Solution

Remote file access occurs over SMB. Remote backups are just another form of remote file access. See File and Sharing Protocol Stack.

If you use SMB over TCP directly (ie. disable NetBIOS) then the port used is 445, both UDP and TCP. If you use NetBIOS then it requires 137 both UDP and TCP, 138 UDP and 139 TCP. See Directly Hosting SMB over TCP/IP:


NetBIOS over TCP traditionally uses the following ports:

nbname            137/UDP
nbname            137/TCP
nbdatagram        138/UDP
nbsession         139/TCP




Direct hosted "NetBIOS-less" SMB traffic uses port 445 (TCP and UDP).

Code Snippets

nbname            137/UDP
nbname            137/TCP
nbdatagram        138/UDP
nbsession         139/TCP

Context

StackExchange Database Administrators Q#56281, answer score: 6

Revisions (0)

No revisions yet.