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 2012 Forums
 Transact-SQL (2012)
 encryption
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

esthera
Flowing Fount of Yak Knowledge

1393 Posts

Posted - 02/20/2014 :  02:09:03  Show Profile  Reply with Quote
I would like to be able to encrypt a string in my program send it to sql and in sql decrypt it

Is there any standard decryption that I can use on both sides?
I use md5 but I need to be able to decrypt it as well

bandi
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 02/20/2014 :  03:40:40  Show Profile  Reply with Quote
Refer
http://www.sql-server-helper.com/functions/string-encryption.aspx
http://sqlmag.com/t-sql/simple-string-encryption-and-decryption
http://www.dotnetheaven.com/article/encrypt-and-decrypt-text-in-sql-server-2008
--
Chandu

Edited by - bandi on 02/20/2014 03:41:12
Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1393 Posts

Posted - 02/20/2014 :  04:16:26  Show Profile  Reply with Quote
thanks -can these encryptions be coded on other apps as well (not with sql) to encrypt on the app side and decrypt on the sql side

is there any standard encrytpion , decryption with key like md5 (md5 won't work here as it can't be decrypted)
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 02/20/2014 :  04:37:32  Show Profile  Reply with Quote
As per these links (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92295 , http://social.msdn.microsoft.com/Forums/en-US/b7b882b2-7fcc-4123-867f-9e774858e93b/decrypt-password-using-md5-algorithm-in-sql-server?forum=transactsql ), MD5 encrypted password can't be decrypted.

Refer this link once...
http://forums.asp.net/t/1649353.aspx


--
Chandu
Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1393 Posts

Posted - 02/20/2014 :  04:48:32  Show Profile  Reply with Quote
i don't want md5

I want a standard encryption method that I can put in the sql -- and on the other program side it can encrypt or decrypt the data
(so code would be both in sql and in app development
)
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.05 seconds. Powered By: Snitz Forums 2000