Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Question on resetting sql user password for sql 2005?

    I have question regarding updating user password in sql 2005.

    Is there a way to update user password in tsql without specify the old password?

    In sql 2000, since we are still able to mess with the data in system table, I can use update statement to update the password field in the login table with encrypted data. But since sql 2005 does not allow users to mess with system tables, I am wondering if there are any ways to update user password without specifying the old password when I use "sa" user to login.

    Thank you.

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    If you login as SA, you can issue the following for the login USER1:

    alter login user1 with password = 'mynewpass'
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts