SQL Agent Erorors

Posted on 2009-04-17
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)
Question by:sqlnewbie08
    LVL 60

    Accepted Solution

    Which server do you get the errors on?

    Author Comment

    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...
    LVL 60

    Assisted Solution

    Sounds more like the connection between the nodes is getting lost, more than a SQL Server related error.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    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.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now