SQL Agent causing errors "Login failed for user 'sa'"

  • Recently we changed the "sa" password on several of our servers. Now one of them (and only one) is constantly logging failures to login. Every minute a record shows up in the log. If I stop the SQL Agent, the errors stop. None of the jobs are failing, and disabling all the jobs does not affect the login errors. I've checked to be sure the agent is using Windows authentication for the Connection page in Properties. I don't get it! Profiler shows the connection with the HostName of the server and ApplicationName of Microsoft SQL Server.

    All suggestions are welcome, other than just leaving Agent off. 😉


    Have Fun!
    Ronzo

  • I think I've "fixed" the problem. I stopped and disabled a replication log reader job that I apparently "missed" the first go-round.


    Have Fun!
    Ronzo

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

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