Sorry to raise if this has been asked before. The SQL Server service is defined as manual, whenever I start it I get (event viewer):
Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.
The SQL Server (MSSQLSERVER) service terminated with service-specific error
Only one usage of each socket address (protocol/network address/port) is normally permitted.
Odd thing both my ethernet and WiFi adapters have ipv6 disabled and it has ran fine for ages.
Environment details:
- Windows 2008-R2;
- SQL Server 2012 BI SP1;
- all MSFT patches applied.