Menu

Showing posts with label configure server to listen TCP/IP port in MS SQL Server. Show all posts
Showing posts with label configure server to listen TCP/IP port in MS SQL Server. Show all posts

How to configure server to listen TCP/IP port on Microsoft SQL Server?

In this article we will look how to configure or enable SQL Server database engine to listen to a particular port.
1. Open MS sql server configuration manager
Goto  SQL server Network Configuration section >> Open protocol for SQLSERVER 
You will see Protocol TCP/IP is showing in Disabled status. By default it is disabled.  

MS SQL Server Configuration Manager
SQL Server Configuration Manager
2. Enable the TCP IP port 
Default it will be Disabled, we have to enable it to listen a server request.
  a. Double click on the TCP/IP option, a new window will appear.
  b. From Protocol tab Select the Enabled value as Yes.

Enable TCP/IP in MS SQL Server
Enable TCP/IP in SQL Server
3. Open the IP Address tab now. Here you will find few IP<n>, and you need to enable the right one and configure with write port.
Here, we will enable our localhost server request on port number 1433. 1433 is default port for MS sql server, which you may change as your wish. Configure the following values here.
Active = Yes

Enabled = Yes
IP Address = 127.0.0.0
TCP Dynamic Ports = <keep it empty>. Default you may find 0 here, please remove the value 0.
TCP Port = 1433
  After making all these changes hit on apply button.
Configure TCP IP properties in MS SQL SERVER
Configure TCP IP properties in MS SQL SERVER

4. If you not sure about the request server and your application is unable to listen to configured IPn, then please update the IPAll section at the end of this IPs with same port number 1433.
IPALL MS SQL Server Configuration TCP/IP
IPALL MS SQL Server Configuration TCP/IP 

Note: These changes will not work until and unless we restart the SQL services. To restart the services. Again go to MS SQL server configuration manager.
Open SQL Server Configuration Manger >> click on SQL Server Service >> SQL Server (SERVER NAME) >> Right click on that and select the restart option.