Monday, March 19, 2012

encrypting a column

We have a SOX requirment that disallows the storing of passwords as plain
text... they must be encrypted in the database. Does SQL Server handle this
natively?Not in 2000. Use Windows authentication or use the MS crypto API / .NET
crypto classes.
SQL Server 2005 will support native encryption and password management
policies for SQL Server logins.
David Portas
SQL Server MVP
--

No comments:

Post a Comment