how to encrypt password to sqlserver

Posted by reddysankark-13471 under C# on 3/15/2012 | Points: 10 | Views : 3498 | Status : [Member] | Replies : 2
hi

how to set password in encrypt format while registering a user with out using login controls.in the same manner how to decrypt that password while login the user

sankarreddy


Responses

Posted by: Sheonarayan on: 3/15/2012 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Reddy...

You can have a look at this article http://www.dotnetfunda.com/articles/article888-encrypt-and-decrypt-a-password-using-encryptbypassphrase-and-decryptbypassp.aspx.

Ideally at the time of logging in you should not decrypt the password but you should encrypt the password entered by the user with the same mechanism you had encrypted while saving and check the value, if both are correct then password is correct else wrong.

Read this thread http://www.dotnetfunda.com/forums/thread1605-problem-in-salt-encryption.aspx for more.

Hope this helps.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/15/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

please refer following links

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78552

http://stackoverflow.com/questions/173329/how-to-decrypt-a-password-from-sql-server

thanks

R D Patel

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response