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 |
|
nbpatil
Starting Member
14 Posts |
 Posted - 2004-10-26 : 21:40:41
|
| Hi..I forgot my password for 'sa' i.e. super user.But i have one more id which have ADMIN access.I want to recover password for 'sa' user.How it can be done?Thanks Nitin Patil |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-26 : 21:50:20
|
| You can't recover it, you can change it to something else though. Since you're not using the sa login for anything except emergencies (RIGHT?????) this won't be a problem. |
 |
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2004-10-26 : 22:22:29
|
| Thanks Rob!!! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-27 : 00:43:19
|
| Here's the password I would suggest.!$#@!JRQWIUWQRU(ERqueworu2j0wu0If that doesn't work, try this one. jaslj09as988y(*y$eh@;AJDIRFP0(y)*(@(y)pu#;ADFThen slap yourself really hard everytime you didn't plan well enough and you have to use it. Better yet, don't write it down even. Then you can fire yourself if you find yourself having to use it. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-10-27 : 08:51:52
|
| Or how about connecting using Windows authentification (as member of Administrators group) and assigning a new sa password? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-27 : 08:53:58
|
| I think that's what he did to fix it. |
|
|
|
|
|
|
Forgot password for 'sa'