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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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?
 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
30421 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  
 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.03 seconds. Powered By: Snitz Forums 2000