Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

password issues Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2008 3:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650
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
Post #514237
Posted Tuesday, June 10, 2008 3:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 9, 2009 6:37 PM
Points: 62, Visits: 221
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
Post #514240
Posted Thursday, June 12, 2008 5:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 6:23 AM
Points: 42, Visits: 325
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'
Post #515783
Posted Thursday, June 12, 2008 5:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
If you are using Windows Authentication for that user, password is to be changed in the Active Directory.
Post #515799
Posted Thursday, June 12, 2008 6:13 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
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..

- Deepak
Post #515827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse