6 Comments

  1. Israel Santiago said:

    Good information. It help me resolve a locked “sa” account in an instance with no Management Studio on it.

    February 23, 2009
    Reply
  2. mRHm said:

    Thanks

    April 16, 2009
    Reply
  3. peter kiedrowski said:

    I see questions about resetting the sa password and enabling the account quite often.

    If you are not comfortable with scripts, this can be done with a few simple clicks.

    1) if you don’t have it yet, download sql 2005 management studio express
    2) login as a windows administrator using win. integrated auth.
    3) go to security, set a new sa password
    4) uncheck ‘disabled’ in status.

    November 12, 2009
    Reply
  4. Mitchel said:

    Thanks,,,, It help me resolve a locked “sa” account.

    January 27, 2011
    Reply
  5. said:

    Peter,

    To be honest I am not certain why I chose to use osql. This was something I had needed a few years back; I am going to speculate that the Express of SQL Management Studio was not available or I had no idea it was available. Thank you for the tip.

    -Aaron

    November 17, 2009
    Reply

Leave a Reply to Mitchel Cancel reply

Your email address will not be published. Required fields are marked *