Log reader log in error

  • Linda Johanning

    SSCertifiable

    Points: 6667

    After a server reboot, the Log Reader job for replication fails with this error "The process could not connect to server 'ServerName'.  The step failed."  In the Log Reader Agent the detail says "Login failed for user 'sa'.(Source: ServerName (Data source); Error number: 18456)". What would cause this?  Nothing has changed on the server, especially not the password.  Anyone ever see this before?

    Linda

  • JR-104739

    SSC Veteran

    Points: 295

    Hi, i get the error some time before, and the problem was a change in sql authentication... was changed to windows aut..

    Check this link, may be help you

    http://support.microsoft.com/default.aspx?scid=kb;en-us;225129

    http://support.microsoft.com/default.aspx?scid=kb;en-us;238477

    JR

  • Linda Johanning

    SSCertifiable

    Points: 6667

    Thanks for the info, but I found the problem.  Under 'Configure Publishers, Subscribing, Distribution' then the Publishers Tab I hit the ellipsis button for 'distribution' and found where the sa account was being used.  I re-typed the password and the Log Reader started right up.  The odd thing is that this password was changed 4 months ago and the Log Reader stopped with the errors after a reboot.  Go figure.

    Linda

  • TrailRunner

    SSCommitted

    Points: 1540

    I was in a similar situation today, and resolved it by right clicking "Replication" folder, then select "Update Replication Passwords...". Here you can re-enter the password, Management Studio will apply to where it is necessary for you.

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

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