March 5, 2008 at 7:39 am
I have to manage (3) production SQL2k5 servers and a couple of test servers, and our IT policy is that the service account passwords have to change every 90 days. So every 3 months I have to login to all the servers via RDP, load up SQL configuration manager, and go to each service to set the new login password. Very time consuming.
I have (2) questions.
1. Is there an easier way? Maybe some tool that would let me do a mass update of services that use this login and password? Am I missing something?
2. Since I use SQL Configuration Manager, How come I cannot figure out how to connect to a remote SQL server from my desktop? Seems I can only connect to the local server?
Thanks!
March 5, 2008 at 8:35 am
I believe there are some freeware tools out there that could assist with such a thing ...
If I were to do it though? I'd say create a procedure to run from an IT/admin related server that uses an openquery with integrated security to connect to each one of your SQL servers in a loop/cursor (based on a control table housing all your SQL server names). Set a variable to randomly generate a password, log that into a new control table with a date that corresponds to the target server, then execute the update against the target server.
Or do the above with the use of vbscript/powershell/c#. Depends on your preference and comfort level of what you use for admin related scripts and such.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply