Error: AES128

#1

I am using Windows 2003 R2......

CREATE SYMMETRIC KEY CIS_Symmetric_Key
WITH ALGORITHM = AES128
ENCRYPTION BY CERTIFICATE CISEncryptionCertificate

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'AES128'.

select @@version

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)

#2

Thanks....

"Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Quote:

It's not AES128, it's AES_128.

You forget to put the underscore between AES and 128

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT

"Rogers" <naissani (AT) hotmail (DOT) com> wrote in message
news:OfoXjaK8HHA.2752 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
I am using Windows 2003 R2......

CREATE SYMMETRIC KEY CIS_Symmetric_Key
WITH ALGORITHM = AES128
ENCRYPTION BY CERTIFICATE CISEncryptionCertificate

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'AES128'.

select @@version

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007
22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition
on Windows NT 5.2 (Build 3790: Service Pack 2)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error: AES128

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Error: AES128 - 09-05-2007 , 11:55 PM

Re: Error: AES128 - 09-06-2007 , 12:25 AM