Possible Duplicate:
port number of SQL Server
SQL Server - What ports to open on firewall to get access
| |||
|
feedback
|
closed as exact duplicate by Chris S♦ Feb 16 at 15:10
This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.
|
It depends. What port is SQL Server bound to? In most cases it's going to be port 1433. | |||
|
feedback
|
|
TCP 1433 should be enough if you use default server instance only. If there're several instances, you need TCP ports for them as well (port number is configured for each instance). For SQL Browser service you need to open UDP 1434. Otherwise, you want be able to see the server in some GUI dialogs (though could type the server name manually) and to connect to the instances by their names (though could connect by directly speciying the port). | |||
|
feedback
|
|
1433 and 1434 are correct for base access. However, if you are using MSDTC then you have a new new can of worms that you need to address. There is a Microsoft KB article on implementing port restrictions for RPC that you will need to follow to restrict the ports that your SQL Server clients will use when communicating with your SQL Server for a transaction that requires MSDTC. The article is: http://support.microsoft.com/kb/154596 | |||
|
feedback
|
|
| |||
|
feedback
|
