Basic Sql server column encryption

Question

Can anybody please tell me How to store user password with encryption in sql server 2008 'step by step' ?? Thanks in advance

Deepika Srivastava · Answer

Hi Akshay refer this link: http://technet.microsoft.com/en-us/library/cc278098(v=sql.100).aspx in this how to encrypt in sql server 2008 is given step by step.

Senthilkumar · Answer

Hi Akshay Please go here... He has explained clearly with more examples.. (very practical oriented article). http://blog.sqlauthority.com/2009/04/28/sql-server-introduction-to-sql-server-encryption-and-symmetric-key-encryption-tutorial-with-script/

Jignesh Trivedi · Answer

hi akshay Please refer http://www.codeproject.com/Articles/14537/The-Art-Science-of-Storing-Passwords it a very good article.

ko gulwade · Answer

HeyAkshay i got ur questionthts really a good question indeed.well all i cn say u cn implement any kind of encryption algo.use MD5CyptoServiceProvider class in the System.Security.Cryptography namespace of the .NET Framework provides a class for performing one-way MD5 encryption.for more details u cn check the following blog.i hope u cn get an idea http://www.4guysfromrolla.com/articles/103002-1.aspx