Symptoms
- 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.
- 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:
Â
- Go to Start > Microsoft SQL Server < SQL_server_version> > SQL Server Configuration Manager.Â
- Go to SQL Server Network Configuration > Protocols for <SQL_server_version>.
- 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:
- Open
services.msc
right-click SQL Server (<instance name>) and click Restart.