Article ID: 948209 - View products that this article applies to.
A server is running an instance of Microsoft SQL Server 2005. When you use a symmetric key to decrypt data in a database of the instance of SQL Server, you receive the following error message:
This problem occurs when the symmetric key is generated by using the data encryption standard (DES) algorithm in Microsoft Windows 2000.
Msg 15273, Level 16, State 1,
The decryption key is incorrect.
Typically, you experience this problem in the following scenario:
The cause of this issue is documented in the following Microsoft Knowledge Base article:
(http://support.microsoft.com/kb/331367/ )Cannot decrypt data using data encryption standard (DES) key across Windows platforms
To work around this problem, use a different algorithm to generate a new symmetric key. Then, use this new key to reencrypt the data. You should use this method before you migrate the database. For example, use the 3DES algorithm to generate a symmetric key.
SQL Server 2005 uses the Cryptography API (CAPI) in Windows to decrypt data. Therefore, this is a limitation in the Windows operating system.
For more information about how to create a symmetric key, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms188357.aspxFor more information about how to encrypt data by using a symmetric key, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms174361.aspxFor more information about how to decrypt data by using a symmetric key, visit the following MSDN Web site:
Article ID: 948209 - Last Review: February 14, 2008 - Revision: 1.1