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

From AutoCount Resource Center
Revision as of 07:53, 23 March 2018 by Keatmeng (talk | contribs) (Created page with "'''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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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?


Tcp being used1.png


Possible Reason:

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


Solution:

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.


Tcp being used2.png


3. Browse to SQL Server Network Configuration 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 TCP/IP on your right.

5. Click on the IP addresses tab for setting.

6. Scroll your mouse to the lowest, you will find the port number under TCP Dynamic Ports or TCP Port. Please change the port number to other number. (EG: 49171, 49172, 50856 etc.)

7. You can now start your SQL Service.


Tcp being used3.png



By: JS 180314, KM 180315, P180322



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations