I'm working on an SQL Server 2005 DB (SQL Server Standard Edition - Version 9.00.4035.00)
I've been told the server that the database is running Microsoft 2003.
When I look in SQL Server DB properties it says Operating System = Microsoft Windows NT 5.2 (3790)
Looking at the operating system details on the server MS Windows 2003 Standard Edition, 5.2.3790 Service Pack 2 Build 3790.
If I create symmetric keys using the following statement everything works fine
CREATE SYMMETRIC KEY TestTableKey2
WITH ALGORITHM = AES_256 ENCRYPTION
BY CERTIFICATE EncryptTestCert
If I try to create an asymmetric keys using the following statement
CREATE ASYMMETRIC KEY TestTableKey3
WITH ALGORITHM = AES_256
ENCRYPTION BY PASSWORD = '#1_2%3*4)5~6';
I get the following error :
Msg 15314, Level 16, State 1, Line 1
Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows.
I know that AES encryption will only work on Windows 2003 which is what people say is the reason for the error message.
Is that the case here, I can use the AES_256 encryption when creating symmetric keys, but only get the error when creating an asymmetric key.
View Complete Post