Changing SQL Server service account passwords enterprise-wide
3
votes
2
answers
1200
views
In the event of a DBA leaving an organization, what options can the surviving team members pursue to change passwords for service accounts portfolio-wide? While using Configuration Manager appears to be the de-facto method, can PowerShell or another scripting or batch language be used to reset them in bulk? I figure if you're changing the login name for the service accounts, Configuration Manager is essential as registry permissions and the like need to be propagated. For just a password change to the existing account however, is a scriptable method OK as long as it's performed during approved maintenance windows for the service restarts?
Asked by MattyZDBA
(1955 rep)
Nov 25, 2014, 06:41 PM
Last activity: Feb 12, 2023, 12:03 PM
Last activity: Feb 12, 2023, 12:03 PM