Originally Posted by Geoff
Sorry to bump an age old thread, but I need to have my sa password to migrate the database to a new machine, inherited the system so no idea what it is. I tried the above method and I get an error saying password change failed because either the account does not exist or I do not have permission. I'm logged onto the machine as administrator.
You can reset the password via a cmd prompt. We had it reset by the LEA so might be worth speaking to them.
you could try the changesapwd executable mentioned but you'll probably run into the same permissions problem.
i'm not sure, but i think it's possible to have windows authentication setup so that a user other than administrator has admin rights, BUT, the actual administrator account doesn't. If this is the case you could try an old user's account - longshot i know.
on the other hand, what type of migration are you doing? if you have a .bak backup file of teh DB you can just create a new SQL server, choose your own SA password and restore using dbattach. Even if you have the mdf/ldf you can copy them to new server and dbattach.