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 2012 Forums
 Transact-SQL (2012)
 encryption

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-02-20 : 02:09:03
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
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2014-02-20 : 03:40:40
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
Go to Top of Page

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-02-20 : 04:16:26
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
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2014-02-20 : 04:37:32
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
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-02-20 : 04:48:32
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
   

- Advertisement -