password issues

  • Hi to all.

    I have small doubt.

    Normally where the passwords for the users are stored. If there is a failed login means probably the user might have forgot his password.

    As a DBA where can we find their passwords and troubleshoot the issues.We are not using any tools. Is there any option like reset password.Normally how can we change the passwords of the users if we want to do.

    Thanks,

    Sandhya

  • Hi,

    You can change the password using enterprise manager,

    Go to security--> Logins and Double click the user name and change the password.

    So simple..........

    Syed Sanaullah Khadri

    DBA

  • SQL Password is a password recovery tool for MS SQL Server 2000, 2005, 2005 Express and MSDE 2000 (Microsoft SQL Server Desktop Engine).

    You can either try to find the original password (this may take a lot of time) or reset the password to a known one.

    For further info , see http://lastbit.com/sqlpassword/

    To set new password :

    sp_password @new = 'newpassword', @loginame = 'loginname'

  • If you are using Windows Authentication for that user, password is to be changed in the Active Directory.

  • Just an additional information ! in Sql 2005 you have this option to reset a passsword even if you don't know the password of any sysadmin Id refer this LINK for more info..

    [font="Verdana"]- Deepak[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

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