Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#2.0
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 9:13am
Edited 10-Jun-13 9:15am
v2
Comments
ryanb31 at 10-Jun-13 14:14pm
   
Where is the password?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I guess you are looking for [MSDN] SqlConnection.ChangePassword Method [^].
Rate this: bad
good
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 Wink | ;)
 
Hope thats what you where looking for Wink | ;)
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 370
1 Sergey Alexandrovich Kryukov 329
2 BillWoodruff 235
3 Afzaal Ahmad Zeeshan 209
4 CPallini 195
0 OriginalGriff 5,560
1 DamithSL 4,476
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,175


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 10 Jun 2013
Copyright © CodeProject, 1999-2014
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