Unable to start MSSQL Server: Server TCP provider failed to listen on [ ‘any’ <ipv6> 1433]. Tcp port is already in use

Symptoms

1. Unable to start MSSQL server, error in Event Viewer > Application:

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

2. Several MS SQL Server instances have the same TCP port in Start > Microsoft SQL Server ** version > SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for > TCP/IP > IP addresses > IPAll > TCP port.

Cause

Another MSSQL server uses TCP port 1433.

Resolution

Connect to the server via RDP and customize TCP port for particular SQL Server version:

1. Go to Start > Microsoft SQL Server < SQL_server_version> > SQL Server Configuration Manager. 
2. Go to SQL Server Network Configuration > Protocols for <SQL_server_version>.
3. Go to TCP/IP > IP addresses, scroll down to the IPAll settings group and change necessary TCP port to any other free port in the range 49152–65535:
4. Open services.msc right-click SQL Server (<instance name>) and click Restart.

Additional information

Configure a Server to Listen on a Specific TCP Port