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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-09 : 09:59:24
|
| How can I change the sa password in sql2k?Thanks |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-09 : 10:07:19
|
| Found the way to do this. Thanks |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2004-11-09 : 13:22:37
|
It's not bad idea to post the solution for others as well. It can save others time. quote: Originally posted by fmardani Found the way to do this. Thanks
Canada DBA |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-11-09 : 16:42:16
|
| security, logins, look for sa account, right click, properties, set the password as necessary. |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-11-09 : 17:29:36
|
| While on the subject it's highly recommended (see numerous other posts) that this password is secure e.g. '@3#£456ddr~&)_={!A]sdfr' and that it is not used as a login account except under extreme circumstances. Ours are around 13 characters and are kept in a safesteveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
|
|
|