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 |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2004-07-08 : 07:01:26
|
| Dear All,I forgot sa password, can i restore sa password without installing or reattach db?thank's all |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-08 : 07:27:22
|
| Maybe....IF you have an server admin userid, you can reset SA password just like any other userid.Why do you need it? You should try and never use SA - I've heard of people who install a server, create a server admin userid, then gets a manager to change the SA password to something only they know), and the manager then locks the SA password away in a safe.my 2c*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-08 : 08:41:12
|
| We have a password that looks something like this:ajsdflj!#@$!ADKF!Q*@#$JFAFjqljrq-1743jfwqQwk$&*!#$UAFfasjdld;jf[pI couldn't swear to it though. Ya know...we just don't ever use it. Chances of someone guessing it are pretty slim.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-08 : 08:53:20
|
| You "literally" never use it? Or you have it written on a piece of paper in a safe somewhere?Just curiousKristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-08 : 09:04:43
|
| It's stored in a directory that two people in the whole company can get to. And we never use it unless we're changing it. If we do ever have to use it it's VERY painful. Of course, we've made exceptions. Now we have the proper accounts in place though, so we never use it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-08 : 09:09:58
|
| You would not believe how many Open SA Applications I have come across. Which Sounds Like Massive stupidity to me. My usual response is “Let me teach you a new word SECURITY”. JimUsers <> Logic |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-08 : 09:42:12
|
| JimL,I sure agree with you. There is NO reason for any application to be even SA "passworded", and we won't even talk about the SA-Blank concept*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-07-23 : 05:59:18
|
| is your problem not being able to login with sysadmin privileges or simply you want to retrieve the sa password? |
|
|
|
|
|
|
|
|
Password sa