Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-11-21 : 10:50:44
|
| Hello All,Do anyone know how to change the sa password at one time across all the SQL servers? Can this be done using SQL script or system commands? Is there any affordable third party tool for this?Thanks much,Indy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-11-21 : 13:22:57
|
| You could use powershell to build a script that loops through each server and updates the password. |
 |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-11-21 : 21:14:15
|
| Thanks all for suggestions.Do you have sample of batch file or powershell script which can refer?Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL admin/sa password reset