It is a common case that many companies are implementing multiple measures to keep their business data secured with the result of pushing multiple password policies as prevention of data breach, therefore the passwords are being changed regularly.
So, in case of a password change the central component is not capable of subscribing on the central repository SQL Server due to errors of validating the outdated login information, therefore the password update must take the place in the central configuration settings, here are the steps to follow in order to accomplish that:
This way the central configuration settings are being updated, where the best fitting solution to this problem is to use a dedicated service account and therefore minimize the manual intervention updating passwords.
