Post reply

forgot the sa password - please help!

  • November 9, 2006 at 5:29 pm

    #670958

    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.

  • November 10, 2006 at 1:53 am

    #671016

    a "mastercard moment"

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

  • November 10, 2006 at 8:53 am

    #671115

    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 ?

  • November 10, 2006 at 9:14 am

    #671122

    Homebrew,

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

    http://keepass.sourceforge.net/

    -SQLBill

  • November 10, 2006 at 5:31 pm

    #671193

    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]

  • November 11, 2006 at 2:59 am

    #671216

    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.

  • November 12, 2006 at 5:01 pm

    #671258

    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.

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

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