changing passwords

  • hai friends,

    can anybody tell me how to change user passwords for sqlserver2000,

    particularly for the username 'sa'

    Thanks/regards

    suman cherukupalli.

  • I assume that you want to change passwords in T-SQL where you can use sp_password procedure:

    sp_password 'old_password','new_password', 'login'

    for example to change password for sa:

    exec sp_password 'foo', 'zoo', 'sa'

    There are few limitations, though: you have to be member of sysadmin or securityadmin

    fixed server role, it cannot be executed inside transaction and it cannot be used to change

    passwords on NT accounts. Read more in Books Online.

    --

    georged


    --
    George

  • on SQL server Enterprise Manager (EM):

    1- go to security folder .. and expand it

    2- go to logins

    3- in the right area, you wil find "sa", so double click on it

    4- in the "password" text box , write your new password

    5- restart your SQL server (or restart your machine

    I hope this helps you

    Alamir Mohamed

    Alamir_mohamed@yahoo.com


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

Viewing 3 posts - 1 through 2 (of 2 total)

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