Password encryption - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Password encryption

Author

Topic

carumuga
Posting Yak Master

174 Posts

Posted - 2009-10-08 : 04:09:50

Hi,

Can anyone tell me the best practices to store the password in the table with the encryption techniques. This table is designed to store the web user name and pwd.

Thanks in advance.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-10-08 : 04:21:14

Hi

May be its useful for u..

http://msdn.microsoft.com/en-us/library/ms174415.aspx

-------------------------
R...

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-10-08 : 04:40:18

1. create a cert
2. password column in varbinary
3. column the value by the cert and convert into varbinary
my way ^^

Hope can help...but advise to wait pros with confirmation...

carumuga
Posting Yak Master

174 Posts

Posted - 2009-10-08 : 06:58:18

DECLARE @HashThis nvarchar(4000);
SELECT @HashThis = 'SHYAM'
SELECT HashBytes('SHA1', @HashThis);
GO
--Returns the value "0x7B3989F17C6CE4348B43D0EA9A281F958F4798ED". Can this be converted into readable format, i.e. back into varchar format...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources