problem with AES_256 algorithm

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

problem with AES_256 algorithm

Author

Topic

rammohan
Posting Yak Master

212 Posts

Posted - 2008-02-14 : 04:55:34

hi,
i am using sqlserver2005 as back end for my project.
actually we developing an stand alone web application for client, so we need to host this application in his server. he is not willing to install sql server 2005 edition in his sever so we r going by placing .mdf file in data directory of project.

but before i developed in server2005 i used aes_256 algorithm to encrypt n decrypt the pwd column by using symmetric keys.it is working fine.

but when i took the .mdf file of project n add into my project it is throwing error at creation of symmetric key that
"Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows."

please suggest me a solution

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

rammohan
Posting Yak Master

212 Posts

Posted - 2008-02-14 : 23:49:12

please gimme a solution

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-15 : 01:09:07

I don't think MS Access has built-in AES capability.
You have to write an AES function or find it on the Internet.

E 12°55'05.25"
N 56°04'39.16"

rammohan
Posting Yak Master

212 Posts

Posted - 2008-02-15 : 21:55:21

hi,
i am not using MS-Access. when i am trying in sqlser2005 enterpise edition its working fine, but when coming to express edition its throwing error

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-02-15 : 22:28:45

show us the code.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

rammohan
Posting Yak Master

212 Posts

Posted - 2008-02-15 : 23:36:31

CREATE PROCEDURE [dbo].[PROC_DECRYPT]
AS
BEGIN
OPEN SYMMETRIC KEY SK_TEST DECRYPTION BY PASSWORD = 'TEST@#2008'
SELECT CONVERT(varchar(256),decryptbykey(PassWord)) as decryptpwd,convert(nvarchar,decryptbykey(SecurityKeyValue)) from tbl_masterlogin where LoginID='SuperAdmin'
close symmetric key SK_AKADMIX
END

when i am running this in sqlserver2005 enterprise its working fine i.e decrypting properly.

but in express edition it is throwing error:
"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 am using AES-256 algorithm to encrypt the data.

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources