SQL server agent stop working (the server threw an exception [0x80010105])

  • TecMath

    SSC Rookie

    Points: 33

    Hi,

    I have cluster SQL (2008) running under windows server 2008. The cluster is working file for both nods. The SQL server agent stop working. I got an error 1069 which is related to failure in login (I did not change the password for SQL or windows). I tried to reconfirm SQL password in SQL server manager but I got an error "The server threw an exception [0x80010105]". The SQL server service is working. However, the SQL server agent not working. The VIA protocol is disable.

  • Phil Parkin

    SSC Guru

    Points: 244440

    The SQL Agent service may (should) run as a different user from both SQL Server and Windows (which is not relevant here). Check the service credentials.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • TecMath

    SSC Rookie

    Points: 33

    Hi,

    I checked and its still not working.

  • Phil Parkin

    SSC Guru

    Points: 244440

    The server threw an exception [0x80010105]

    Did you Google this error? I just did, and there are lots of hits. Based on the knowledge you would have accrued from the hits, what have you tried already?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply