SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Unsafe chars in SS 3DES encryption?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chamberssh
Starting Member

6 Posts

Posted - 08/19/2010 :  07:11:07  Show Profile  Reply with Quote
Hi,

I have used SQL Server's encryption to encryt/decrypt certain column data.

i.e. as in the article: http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx#596

I then include this decrypted value to send an email using database mail (using the encrypted values), thus an example:

hi.
please click on link
response.aspxid=0x000A45397C738846879A1A3E2FED78720100000005814AA656AF7990648901AEB731C095A8180B667EE44C13

what I need to know is : does sql server encryption method used contain any unsafe chars that will cause an issue in the querystring, i.e. like \ or &?

BTW in my sql server setup i use des3, i.e.:

CREATE SYMMETRIC KEY TestEncryptKey
WITH ALGORITHM = TRIPLE_DES
ENCRYPTION BY CERTIFICATE TestEncryptCert

SwePeso
Patron Saint of Lost Yaks

Sweden
30208 Posts

Posted - 08/19/2010 :  07:53:14  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Only if you used the "unsafe" characters when encrypting the value.
With that I mean the ASP page doesn't decrypt the value.
You have to do that yourself inside the page.


N 56°04'39.26"
E 12°55'05.63"

Edited by - SwePeso on 08/19/2010 07:54:37
Go to Top of Page

chamberssh
Starting Member

6 Posts

Posted - 08/20/2010 :  06:51:33  Show Profile  Reply with Quote
great thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000