@Sue_H  - I like the reference to the loaf of bread....very funny! I got a good laugh out of that 😉

@ Ok thanks Steve....so if  through windows programming we change the password in AD and then in all local services, we don't need to touch configuration manager? correct?

@steve-2 Jones - it is the changing of the password in config manager that is going to be the issue, the windows server admins should be able to...

@Joie Andrew - that's a good option for sqlserver 2012...

@arsh-2 - Thanks but for the second question  passwords are already set to never expire. The issue is for some crazy reason auditors want them changed...every account password.

Thanks Anthony its another good option if  required.

Regarding changing a password on multiple servers, it's actually quite simple if you have them registered as servers in your SSMS. In the Registered Servers pane, right-click the name of the...

@ed - Thanks that code it is very useful.

Another more complex challenge is to alter the password for an SA account on 100+ different sql instances, all on...

Thanks Sue I will stick with the sql, using a password generator for the passwords, with some excel concatenation to create a long list of password alterations and run it...

Yeah Sorry Sue the above is just an example, please ignore the syntax.

I was wondering if there was an easier way in powershell or a way to auto...

Great, Many thanks for your response.

Will this not work to a certain extent also?

SELECT MAX(login_time) AS [Last LoginTime], login_name [Login]