Hi Experts,
We fail overed one of our database server to another node earlier today(for testing purpose), Since then the replication from that server stopped working with the above mentioned error.
After around 30 minutes of troubleshooting it was finally resolved by changing the run as of step 2 to 'SQL server agent account', however I wanted to know what could be the root cause of this.
Would it be an issue with the password change policy for account 'ABC\ashif' on the windows level?
Any help would be appreciated.
Note - 'ABC\ashif' is the sysadmin of the DB server