forgot the sa password - please help!

Question

forgot the sa password - please help!

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 1

You cannot normally copy / paste an MDF if SQL Server is running, so, since your server is not running then copy / paste should work just fine.

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 2

a "mastercard moment"

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

I'm trying to come up with a secure way to write down my passwords to avoid these emergencies. Something along the lines of saving a list of just passwords somewhere, and a list of just account names somewhere else. Then you would need both lists in order login. You could even encrypt the name & login one way or another.

Any thoughts ?

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Homebrew,

You really should have started a new thread on this, but....

http://keepass.sourceforge.net/

-SQLBill

Luke L SSC-Dedicated Points: 35547 More actions · Answer 5

My CFo or CIO's safe has always worked for me...

To help us help you read this[/url]For better help with performance problems please read this[/url]

Deepak Kuamr Singh Newbie Points: 1 More actions · Answer 6

logon to the box with the local admin.

Open Sql Enterprise manager. Rt. click on the server registration properties and change it to windows mode of authentication and register.

You will be able to expand in to the details of the SQL server security. Go ahead to reset the passoword of SQL server Login which ever is even sa.

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 7

Thanks Guys. This discussion has been great.

I am keeping a list of all passwords in a secure place, but didn't know I could use CIO's/CFO's safe as well

Thanks guys. I have been able to retrieve the databases by copying the actual files themselves. Did have some trouble with the users though. Anyway, Thanks heaps again.