Configuring TCP/IP properties
Select Start > SQL Server 2014 Configuration Manager.
The SQL Server Configuration Manager opens.
From the navigation tree, select SQL Server Network Configuration > Protocols for MSSQLSERVER, as shown in Figure 35.
Figure 35: SQL Server Configuration Manager
Right-click TCP/IP and select Properties from the shortcut menu.
The TCP/IP Properties dialog box opens, as shown in Figure 36.
Figure 36: TCP/IP Properties dialog box
On the Protocol tab, make sure Yes is selected for Listen All.
Click the IP Addresses tab, select Yes for the Enabled option of each IP address, and set TCP Port to 1433, as shown in Figure 37.
Figure 37: IP Addresses tab
Click OK.
The system displays a message that indicates the database service must be restarted to validate the configuration.
Click OK.
Restart the SQL Server service. For more information, see "Restarting the SQL Server service."
![[NOTE: ]](images/note.png)
NOTE:
When Yes is selected for Listen All on the Protocol tab, the SQL Server automatically updates IP address settings after an IP address is changed. If you selected No, you must manually update the IP addresses.
You can enable the Named Pipes property in the same way.
In distributed deployment, make sure you configure all database servers to use the same listening port.
