Automatic local user and MS SQL password changing

Vai · 14 May 2007 at 12:23

Hi,

To try and be more secure the company I work at wants all admin level passwords changed every 3 months.

The two largest groups of passwords are the local admin passwords for the users/servers, and the Microsoft SQL (2000 + 2005) SA passwords.

Can anyone suggest a piece of software that can automate the changing and storing of these passwords?

Thanks

optimus · 14 May 2007 at 13:29

You can do this with a computer startup script with group policy.

If you google it, you should find some examples.

Vai · 14 May 2007 at 16:31

Thanks, I found the script for using group policy to change the local administrator password, however there doesn't appear to be anything for bulk changing SQL sa passwords

optimus · 14 May 2007 at 17:13

To be honest, I'm not sure about that one, is there not a risk associated with scripting this? or are these just for MSDE instances for developers etc?

Could you use an OSQL command on the same computer startup script?