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.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2010-12-31 : 12:19:49
|
| Guys,I need some assistance.I have been following the script here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258I got the functions successfully run but I am having a difficult time decrypting a password.For instance, according the script, you can decrypt an encrypted password like this:select dbo.fnEncDecRc4('myusername','IUHGGG+4DYMFY513W47Izem9s?') from myUsersTable where username='myusername'When I run this in query analyzer, I get the same encrypted password:________________________IUHGGG+4DYMFY513W47Izem9s?What am I doing wrong?Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-12-31 : 13:20:05
|
Drop the single quote, because you want to get the value from the table.select dbo.fnEncDecRc4(password_column_name_here, 'IUHGGG+4DYMFY513W47Izem9s?') from myUsersTable where username = 'myusername'
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Decrypting a password