Configuring SQL server instance to listen to a specific port as instance port can change. SQL Serer default instance listens to port 1433. However if Named Instance is configured then by default the port is changing dynamically. To enable SQL server to listen to port, ALL the IP Addresses for the instance including the Loopback and IPALL needs to be changed to the specified Port ... See Below:
How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager): "In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll. One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer. Right-click each address, and then click Properties to identify the IP address that you want to configure.
"
'via Blog this'
No comments:
Post a Comment