Click here to Skip to main content
13,045,657 members (66,100 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I want to apply a facility in my windows application through which the user can retrieve the password of SQL Server if he forgot it and can change the password SQL Server if required. I don't know how to do this task. I need help.
I developed my application by using C#2.0 and SQL Server 2005
Posted 10-Jun-13 8:13am
Updated 10-Jun-13 8:15am
ryanb31 10-Jun-13 14:14pm
Where is the password?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I guess you are looking for [MSDN] SqlConnection.ChangePassword Method [^].
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

You cannot do that.
First of, the password is hashed on the server, so you cannot get it in plain text.
Next, if hi forgot the password, how would he be able to logon and change the password ???? hi cant, thats whats admins are for.
BUT you could have a static user with the ability to call the ALTER LOGIN[^] but i dont recomment it ;)

Hope thats what you where looking for ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 10 Jun 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100