June 10, 2008 at 3:15 am
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
June 10, 2008 at 3:23 am
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
June 12, 2008 at 5:05 am
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'
June 12, 2008 at 5:35 am
If you are using Windows Authentication for that user, password is to be changed in the Active Directory.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply