Post reply

Is it best practice to change the password for distributor_admin?

  • November 23, 2022 at 4:37 pm

    #4117146

    Hello,

    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.

    Thoughts?

     

    Thanks.

     

    • This topic was modified 2 years ago by  WebTechie.

    Things will work out.  Get back up, change some parameters and recode.

  • November 24, 2022 at 5:10 pm

    #4117667

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • December 5, 2022 at 5:12 pm

    #4122157

    When I worked at a Fortune 100 company, passwords that were used by machines only, and not people, had a 12 month password change cycle. Changing machine only passwords every 90 days introduces risk that the password will not be set correctly, and will cause an outage.

    If you have a privileged ID password storage system, make sure it gets updated with the new password.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply