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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-27 : 09:28:16
|
| Sissi writes "Hi Guys,I need to change 'SA' Account password on the entire system.How do I do that? Many thanks." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-27 : 13:02:32
|
| Logged in as SA, you can do it through Enterprise Manager, in the Security folder.Or You can use sp_password.-Chad |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-27 : 14:48:07
|
| What do you mean by "Entire system". Are you trying to change the sa password on all the servers in your network?Anyway, you can either change it from Enterprise Manager or use sp_password from Query Analyzer. You can even try SQL DMO, if you fancy a bit of programming ;-)--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
|
|
|
How to change password