Microsoft SQL Server 2005 Database Encryption Step-by-Step

华风

In the above CREATE SYMMETRIC KEY t-sql statement one important point is the algorithm parameter that is specified in the command.　　Microsoft SQL Server can use the following algorithms in encryption sensitive data.
　　DES, TRIPLE_DES, RC2, RC4, RC4_128, DESX, AES_128, AES_192 and AES_256
　　As system administrators or database admins, one important note for AES_128, AES_192 and AES_256 is AES encryption algorithm can not be used on Microsoft Windows 2000 Servers and Windows XP operating systems. If you have a MS SQL Server instance running on a Win2k server, then it is better to create the symmetric keys using the TRIPLE_DES algorithm, for instance. Otherwise, your script will fail when it is run on a sql server which is installed on Windows 2000 servers and Windows XP computers since AES is not supported on those operating systems. You should consider this point while choosing an encryption algorithm for your SQL Server database applications.