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...
Friday, February 5, 2016
Subscribe to:
Posts (Atom)
How to interpret Disk Latency
I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...
-
Sharding is a data partitioning technique which is popular in NoSQL databases like MongoDB and Cassandra. You can scale out the data set h...
-
I'm super excited to hear about the news, the first release of CTP (Community Technology Preview) of SQL Server on Linux at Microsoft ...
-
In-Memory OLTP, code named Hakaton is a separate database engine introduced in SQL Server 2014 and it is combined with SQL Server traditio...
