SQL Cluster: Failover not happening

Question

SQL Cluster: Failover not happening

sivaprasad

SSCertifiable

Points: 6183
More actions
August 23, 2004 at 2:12 am

#360693

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] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

Any help on cause of the problem and resolution will be apprieciated.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gopal-122691 Mr or Mrs. 500 Points: 517 More actions · Answer 1

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

sivaprasad SSCertifiable Points: 6183 More actions · Answer 2

Gopal,

Sorry, the box is running on Windows 2003 Enterprise Edition without any service packs.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

josegarcia Valued Member Points: 69 More actions · Answer 3

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.

cspangler Say Hey Kid Points: 704 More actions · Answer 4

hi, i came across this posting and was wondering if anyone found out the resolution. i encountered the same problem today and came across this posting...from 2004.

i have an active\passive windows 20003 enterprise sp1, sql 2000 sp4 enterprise environmnet.

i'd appreciate any input.

thank you...

Rich Morrissey Valued Member Points: 60 More actions · Answer 5

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

Rich Morrissey Valued Member Points: 60 More actions · Answer 6

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

snivas Say Hey Kid Points: 713 More actions · Answer 7

Dear all,

I also came across the same issue,can any body has solution for this issue ?

OS Name: Microsoft(R) Windows(R) Server 2003, Enterprise Edition,

OS Version: 5.2.3790 Service Pack 2 Build 3790

with

SQL Server 2000 SP4

Thanks in advance

snivas Say Hey Kid Points: 713 More actions · Answer 8

Dear all,

I also came across the same issue every month,

SQL Server 2000 SP4

with

OS Name: Microsoft(R) Windows(R) Server 2003, Enterprise Edition,

OS Version: 5.2.3790 Service Pack 2 Build 3790

Thanks in adavance