Friday, February 5, 2016

Another process has taken SQL Server assigned port

I received the below error while I was doing failover testing on a newly built SQL Server 2012 cluster.
The SQL Server (MSSQLSERVER) service terminated with service-specific error An attempt was made to access a socket in a way forbidden by its access permissions..
After few troubleshooting I found this was due to the port ​xxxxx was taken control by another process. Apparently the process was Cluster Manager. :) So I closed the Cluster Manager and re-opened and then failover was successful. This seems to be very rare occurrence but it is possible.
Refer the below link for more details;

Server TCP provider failed to listen on...

No comments:

Post a Comment

Transitioning of SQLOS to SQLPAL

​ The SQLOS​ Prior to SQL Server 2005, SQL Server runs as a user mode process like any other Windows application and it depends on...