var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL error found in eventviewer
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,
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.