?
Solved

SQL Agent Erorors

Posted on 2009-04-17
3
Medium Priority
?
862 Views
Last Modified: 2012-05-06
We are running sql 2005 cluster.  Replication is set up on this instance.  We have been getting the following errors sporadically.  Can someone provide some insight to this errors:
failed (ConnUpdateJobActivity_NextScheduledRunDate)
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]
165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
[382] Logon to server '(local)' failed (ConnAttemptCachableOp)
[382] Logon to server '(local)' failed (ConnAttemptCachableOp)
0
Comment
Question by:sqlnewbie08
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 1500 total points
ID: 24167296
Which server do you get the errors on?
0
 

Author Comment

by:sqlnewbie08
ID: 24167323
We are running multiple instances on 2 nodes.  I noticed we get these types of messages on 3 of the servers which are either running replication or have a linked server set up...
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 1500 total points
ID: 24167366
Sounds more like the connection between the nodes is getting lost, more than a SQL Server related error.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question