July 6, 2024 at 12:32 pm
Dear all,
What is the reason and fix for the below error?
The Replication_User is used in Security Agent settings for LogReaderAgent for the Publication. How does the password get expire?
2024-07-06 12:09:56.405 User-specified agent parameter values:
-Publisher <<>>
-PublisherDB <<>>
-Distributor <<>>
-DistributorSecurityMode 1
-Continuous
-XJOBID 0xEEED30FA6AF9FA49B4455A5C0FA4E4EE
-XJOBNAME <<>>
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER <<>>
-XCMDLINE 0
-XCancelEventHandle 0000000000001DD8
-XParentProcessHandle 000000000000217C
2024-07-06 12:09:56.467 Status: 32768, code: 53044, text: 'Validating publisher'.
2024-07-06 12:09:56.498 Status: 0, code: 20015, text: 'Login failed for user 'Replication_User'. Reason: The password of the account must be changed.'.
2024-07-06 12:09:56.498 Login failed for user 'Replication_User'. Reason: The password of the account must be changed.
2024-07-06 12:09:56.498 Status: 0, code: 22037, text: 'Login failed for user 'Replication_User'. Reason: The password of the account must be changed.'.
July 7, 2024 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 9, 2024 at 1:06 pm
The issue was with the Windows login Replication_user.
The password policy was setup to expire the password of that user and so the password was expired which caused the issue.
Once the password is reset - no error.
September 9, 2024 at 1:06 pm
The issue was with the login Replication_user.
The password policy was setup to expire the password of that user and so the password was expired which caused the issue.
Once the password is reset - no error.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply