Search

Monday, May 14, 2012

Clustered SQL Server fail to start

Today 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 have 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"

No comments:

Post a Comment