Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Post Unanswered: SQL error found in eventviewer

    Hi,

    we have a active/passive cluster server with SQL server 2005 SP2 installed.
    i have found the following error messages in event viewer application log for MSSQLServer:

    1) [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.
    2) [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
    3) [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
    4) [sqsrvres] OnlineThread: QP is not online.

    can any one pls help me finding out the solutions.
    Thanks in Adv,
    Praneetha.

  2. #2
    Join Date
    Jul 2007
    Posts
    9
    Hi Praneetha....are you running remote queries? Do you have linked servers? I saw a similar error when messing around with linked servers in my 2005 dev environment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •