Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server
how to encrypt a password field in sql server2005?
Posted 20-Oct-12 13:41pm
Edited 20-Oct-12 13:59pm
Nelek63.5K
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Kindly refer this.
It is well explained and sample code also available.
 
Different Level of Encryption in SQL[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Often a oneway "encryption" is sufficient: add some "salt" to the clear text password, then hash it with MD5, SHA1 or other hash functions. When the user tries to log in, just follow the same procedure and compare the "encrypted" values.
If you need to retrieve the original clear text password from the value stored in the database, you need a real encryption method. The System.Security.Cryptography namespace offers some methods.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

you Can use this coding for making secure password
 
 
	
 
string s = "Foo bar";
string s1 = Convert.ToBase64String(Encoding.Unicode.GetBytes(s));
 
' And back...
string s2 = Encoding.Unicode.GetString(Convert.FromBase64String(s1));
 
thanks
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  

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

  Print Answers RSS
0 DamithSL 440
1 OriginalGriff 194
2 BillWoodruff 170
3 Zoltán Zörgő 165
4 Maciej Los 163
0 OriginalGriff 7,934
1 DamithSL 6,084
2 Sergey Alexandrovich Kryukov 5,449
3 Maciej Los 5,174
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 22 Oct 2012
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