MSSQL Server does not start: Tcp port is already in use

Created:

2016-11-16 13:14:57 UTC

Modified:

2017-08-08 13:37:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MSSQL Server does not start: Tcp port is already in use

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

MSSQL Server could not start with error:

    Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use.

Cause

The port of SQL Server is used by another process.

Resolution

Check service uses SQL Server port with netstat (default port for SQL Server is 1433):

    netstat -a -n -b

You see something like that:

    Local Address          Foreign Address        State

TCP
0.0.0.0:1433 0.0.0.0:0 LISTENING

[services.exe]

Stop mentioned service or change port to other one.

Have more questions? Submit a request
Please sign in to leave a comment.