Brief on the current environment:
SQL Server 2000 Enterprise Edition
Windows 2000 Enterprise Edition
Service Pack 3a and KB 859 - Prerequisite applied.
Active/ Passive cluster
Problem:
Automatic failover is not happening.
Errors found on SQL Error Log:
Waiting for type 0x4, current count 0xa, current owning EC 0x43D37588.
Time out occurred while waiting for buffer latch type 4,bp 0x2d9c780, page 1:41), stat 0xb, object ID 2:2:0, EC 0x54DF3570 : 0, waittime 300. Not continuing to wait.
Errors on NT Event Viewer:
Event Id: 17052
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 274c; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Any help on cause of the problem and resolution will be apprieciated.
Siva,
We had the similar problem sometime back. We couldn't find out what is causing this problem. We applied Post W2K SP4 Cluster fixes and we believe it has fixed the problem.
Gopal
Gopal,
Sorry, the box is running on Windows 2003 Enterprise Edition without any service packs.
Hi Sivaprasad,
I have the same problem with a SQL2000 Cluster in Windows 2003 Enterprise Edition.
Dou you know how to solve the problem?
Thank you.
Hi,
I am having the same problem now, though in my case it occured after upgrade to Windows 2003 sp 1.
Uninstalling the SP resolved the issue, but we need to get sp 1 installed
