Hi
I need to update the password for distributor admin.
I see there is a procedure to do this:
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-changedistributor-password-transact-sql
Does the administrator admin account just exist on the sqlinstance where the distributor databases exists? or would I need to run this command on the publisher, distributor and subscriber?
thanks in advance