Clustered SQL Server fail to start


I got the following error:
The SQL Server (INST1) service terminated with service-specific error 10048 (0x2740).
and also

Server is listening on [ 192.168.51.27 1433].
Server TCP provider failed to listen on [ 192.168.51.27 1433]. Tcp port is already in use.
TDSSNIClient initialization failed with error 0x2740, status code 0xa.
The root cause of this issue is because of cluster checkpoint service behavior. If a setting is changed while the resource is online, that change will get check-pointed to the CPT hive file in the cluster quorum disk.
To fix it follow the instructions specified on: http://support.microsoft.com/default.aspx?scid=kb;EN-US;912397
cluster res "SQL Server" /removecheck: "Software\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLSERVER"
Correct the protocol parameter for the clustered instance of SQL Server on all nodes
cluster res "SQL Server" /addcheck: "Software\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLSERVER"
Tags: , , ,

About author

Vittorio Pavesi