View source for Troubleshooting: SUnable to start SQL Server Service due to TCP Port is already being used

'''Question:''' I am unable to start my SQL Server service. I found an error in my event viewer stating – Server TCP provider failed to listen on [ `any` <ipv4> 49170]. Tcp port is already in use. How can I fix this?

<b>Version:</b> 1.8 / 1.9 / 2.0

[[File:Tcp being used1.png]]



<u><b>Possible Reason:</b></u> 

The port number 49170 (in this case) is being used by another program.



<u><b>Solution:</b></u>

You will need to change the port number that runs this SQL service to start.

1.	Click on your window start button / search button and search for your SQL Server Configuration Manager.

2.	Click to open SQL Server Configuration Manager.


[[File:Tcp being used2.png]]


3.	Browse to <span style='color:red'>SQL Server Network Configuration</span> and select Protocols for A2006 (default for AutoCount, you may select your desire instance if you had changed it during installation).

4.	Double click on the <span style='color:red'>TCP/IP</span> on your right.

5.	Click on the <span style='color:red'>IP addresses</span> tab for setting.

6.	Scroll your mouse to the lowest, you will find the port number under <span style='color:red'>TCP Dynamic Ports</span> or <span style='color:red'>TCP Port</span>. Please change the port number to other number. (EG: 49171, 49172, 50856 etc.)

7.	You can now start your SQL Service.


[[File:Tcp being used3.png]]


<br/>
By: JS 180314, KM 180315, P180322



{{NavigateForUser}}