SQL Server Cluster Failures

Hi Experts,

We are on SQL Server 2005 Std 64 bit and Win 2003 Server with 4 instanced Active/ Active cluster  instances on two nodes.

Have been getting  Cluster errors and SQL Server resources of all instances are failing very frequently. SQL Server is not Failed Over. It is also not resatred during most of the times.

Below are the errors from the event log:

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqsrvres] OnlineThread: QP is not online.

Can you please take a look and tell me what could be the issue.

Thanks,
LVL 8
dba2dbaAsked:
Who is Participating?
 
r_panosCommented:
Some more informations should be useful:

What kind of hardware do you use (vendor, family, generation ecc, p.e. HP DL380 G5)
Can you check the application and system event viewer for concurrent errors?
What speed the public NICs are set to (autosense, 100Mb ecc)

For the issue of not failing over or not restarting you must provide the properties of the SQL Server resource in cluster (the advanced tab) and the properties of the SQL Server cluster Group

0
 
Jim P.Commented:
Is the cluster IP range on a separate network fro your public network?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.