December 29, 2004 at 10:01 am
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
December 29, 2004 at 1:04 pm
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
December 30, 2004 at 6:03 am
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
October 23, 2015 at 11:45 pm
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply