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