Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a 2 node cluster (NODE-A & NODE-B) with 2 SQL instances spread between them. INST1 prefers NODE-A, INST2 prefers NODE-B. INST1 started generating errors then, failed over to NODE-B. Migrating INST1 back to NODE-A generates the connection errors after it logs a "Recovery is complete." message.

Win 2008 R2 Ent.
SQL 2008 R2 Ent.

Errors from the Event Log after first failure:

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]Query timeout expired
[sqsrvres] OnlineThread: QP is not online.
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]The connection is no longer usable because the server failed to respond to a command cancellation for a previously executed statement in a timely manner. Possible causes include application deadlocks or the server being overloaded. Open a new connection and re-try the operation.
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]Login timeout expired
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = ffffffff; message = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
share|improve this question
    
What SAN/controller please? –  gbn Feb 14 '11 at 19:13
    
Not sure of specifics but I know EMC's PowerPath is involved. –  Eric Humphrey - lotsahelp Feb 15 '11 at 17:08
    
Do you have any startup procedures? –  mrdenny Mar 5 '11 at 10:39
    
Good question. I'll check Monday morning. –  Eric Humphrey - lotsahelp Mar 5 '11 at 14:52
add comment

2 Answers

Please check if changing the time-out value for the SQL Server Resource in the Cluster Administrator helps.

share|improve this answer
    
I'm not seeing a time-out value in the properties for the SQL instance in the Cluster Admin. –  Eric Humphrey - lotsahelp Feb 14 '11 at 16:55
add comment

Check SQL server configuration manager and see if the SQL browser is turned on. Check to see if dynamic ports are used or that 1433 is not being used by something else.

Also, try: sp_configure 'remote access' and let me know what is returned.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.