Our audit team has decreed that all logins should password policy turned on for all SQL Server logins.
They also decreed that the login password needs to be 32 characters.
I found the command to change the password: sp_changedistributor_password
The question that I have, is this something that is going to break my replication?
Is it best practice to have the distributor_admin set to adhere to the password policy and change every 90 days?
If not, I will submit an exception to policy if this will negatively impact our replication.
- This topic was modified 10 months ago by WebTechie.
Things will work out. Get back up, change some parameters and recode.