changing sql services password
In my environment, I have over 100+ servers and every so many days, the account that runs SQL services are changed and it is a bitch to change it via point and click on 100+ servers.
Internally, there’s a tool that we all can use to reset password for services except that it isn’t friendly when you have active/active setup. The following script changes all that via the use of powershell. Of course, this is version 0.1. version 0.2 will be written in C# but that’s for later.
The script will create a table in a database, you will then need to populate the table with the physical server, SQL instance name (not the virtual name!!). Once that’s done, run the bottom portion of the script to output the powershell statement; which you will copy & paste into a powershell cmd screen.
Once you pasted it, powershell will start executing all the commands. After Powershell stop running the command, be sure to press ‘Enter’ to make sure that the last command actually get executed. I know it is still a bit manual but better then pointing and clicking thru 100+ servers to change a bloody password.
