Overview
Problem / Symptoms:
In Event Viewer, it shows:
The SQL Server (SQL2012) service terminated with service-specific error Only one usage of each socket address (protocol/network address/port) is normally permitted.
It means the port SQL was set to use is already in use.
Diagnosis:
Solution / resolution:
Go to SQL connection manager and then to Protocols for the SQL version. Go to TCP and then the IP address tab. Clear the port number at the bottom.