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.  

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 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

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 

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.

References:

• configure a server to listen on a specific tcp port

Hissa

Hum mehnatkash jagwaalon se jab apna hissa maangenge
Ek khet nahin, ek desh nahin, hum saari duniya maangenge

Yaan sagar sagar moti hain, yaan parbat parbat heere hain
Yeh saaraa maal hamaara hai, hum saara khazaana maangenge

Jo khoon baha, jo baag ujde, jo geet dilon mein qatl hue
Har qatre ka, har ghunche ka, har geet ka badla maangenge

Se seth byopaari rajwaade dus laakh to hum das laakh karod
Yeh kitne din America se jeene ka sahaara maangenge

Jab saf seedhi ho jaayegi, jab sab jhagde mit jaayenge
Ham har ik desh ke jhande par ik laal sitaara maangenge

-- Faiz Ahmed Faiz

Communal violence and commissions on riots in India

India experienced many communal violence is past and still it is happening, even we are in 21st century and billion of our civilians are literate.

Post independence government of India form few committees to inquiry some deadly and highly impacted riots. Below is the list of the few committees.

1. 1961 Jabalpur riots, Justice Shiv Dayal Srivastava Committee
2. 1967 Ranchi riots, Raghubir Dayal Commission
3. 1969 Ahmedabad riots, Justice P Jaganmohan Reddy
4. 1970 Maharashtra riots, D P Madan Commission of Inquiry
5. 1979 Jamshedpur, Bihar, Jitendra Narain Commission of Inquiry
6. 1980 Moradabad, Justice M P Saxena
7. 1981 Biharsharif, Bihar, Balasubramanian Commission
8. 1984 Delhi, Justice Jaggannath Misra Commission 1985 and Justice Nanavati Commission 1999
9. 1989-90 Bhagalpur Communal Riots Inquiry Commission
10. 1992-93 Bombay, Justice Srikrishna Commission
11. 1998 Coimbatore, P R Gokulakrishna Commission of Inquiry
12. 1999 Manoharpur, Orissa Wadhwa Commission probed burning of Graham Staines
13. 2002 Ahmedabad, Justice Nanavati and Justice K G Shah
14. 2011 Gopalgarh, Rajasthan Justice Sunil Kumar Garg Commission
15. 2013 Muzaffarnagar, Justice Vishnu Sahai Commission 

Million of riot victims are still waiting for justice from judiciary. These commissions are failed to find any solution to stop the violence in future. Recently, in year 2020 "Delhi Riot", Capital city of India, New Delhi gone by 5 days riots between Hindu and Muslim community which killed more than 50 people. This is the situation of capital city of India, law and order of Delhi police. Many eyewitness said new agencies that "Police joined the rioters and supporting rioters to raise the violence."

Reference:

• Communal Violence and Justice
• Commissions on riots in India
• Delhi police participated in February riots
• List of riots in India
• Why India's Muslims Are in Grave Danger
• Police biased didn't stop riots
• Understanding Communal Violence in India since 1947
• Delhi police accused of filing false charges over February riots