SQL Server Performance

SQL Job Failures

Discussion in 'SQL Server 2005 Clustering' started by rfalor, Nov 13, 2006.

  1. rfalor New Member

    I have a sql job that was just implemented on a new SQL2K5 cluster.
    The job fails with no SQL error log entries; the following errors are in the cluster.log file, Event Log & Agent log
    I'm not a network or cluster expert. Any help greatly appriciated

    CLUSTER.LOG & EVENT LOG
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 40; message = [Microsoft][SQL Native Client]TCP Provider: The specified network name is no longer available.
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 40; message = [Microsoft][SQL Native Client]Communication link failure
    ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
    ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
    ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

    SQL Agent LOG
    [298] SQLServer Error: 64, TCP Provider: The specified network name is no longer available. [SQLSTATE 08S01]
    [298] SQLServer Error: 64, Communication link failure [SQLSTATE 08S01]
    [298] SQLServer Error: 10004, Communication link failure [SQLSTATE 08S01]
  2. gurucb New Member

    I think the cluster failed over to secondary node.. please also share sql server error logs.
  3. satya Moderator

    Make sure Cluster service is able to connect to SQL server, check event viewer logs too including cluster.log file.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  4. MohammedU New Member

    Check the cluster service account permissions...
    Check BUILTINAdministrator login exists in SQL and check its permissions too.

    Mohammed U.

Share This Page