Free Encryption

Question

Post reply

Free Encryption

Viewing 15 posts - 136 through 150 (of 153 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 736212

August 9, 2010 at 8:16 am

#1204187

I'll post the file here. good luck.

Mike C SSC-Insane Points: 23224 More actions · Answer 2

IIRC you were looking specifically for the blowfish or twofish encryption, correct? If so I have .net/clr versions that would be better to run on 2005/2008 (32 or 64 bit). I just finished testing them against the published test datasets. Send me an email offline if you'd be interested.

Thanks

Mike C

cygnussolutions Grasshopper Points: 20 More actions · Answer 3

Hi all,

A while back I compiled the 32 bit version of the blowfish encrypt and decrypt dlls for the 64 bit environment. No functionality changes to the code were made. I've been using them for several months now in our SQL2008 64 bit environment on data that was upgraded from a SQL2000 database and encrypted using the 32 bit version. Works like a charm. I've attached the 64 bit dlls.

Cheers!

djspub SSC Enthusiast Points: 106 More actions · Answer 4

Nice post and useful toolkit.

I notice that the function definitions in your ADD.SQL script use varchar(2000) rather than varchar(max). Are there limits on the size of the data that can be passed to the base64encode and base64decode procedures? From a brief look at the .cpp files, it would seem like there are not limits, but I did not do a thorough code review. Would be helpful to know that these routines can arbitrarily large strings.

Thank you,

David

Mike C SSC-Insane Points: 23224 More actions · Answer 5

Hi David,

This was actually created for SQL 2000--before we had the max data types. There could be a chance the XP API (extended proc API) won't handle max data types properly, but I'm not 100% sure on that--I haven't looked into the XP API in quite a while now. I'm working on CLR versions of these utilities for 2005 and 2008 (and R2) but that project's not complete yet.

Thanks

Mike C

Leju Geevarghese SSC Eights! Points: 982 More actions · Answer 6

xp_blowfishencrypt and xp_blowfishdecrypt will not work in 64 bit environments.

Please stay away from this encryption method as you may have trouble when migrating to a 64 bit box.

Why not use SQL server encryption?

---------------------------------------------------------------------------------------
It begins by taking the first step.

Mike C SSC-Insane Points: 23224 More actions · Answer 7

None of the XPs here were distributed as 64 bit. SQL 2000 doesn't have built-in encryption.

Thanks

Mike C

djspub SSC Enthusiast Points: 106 More actions · Answer 8

I am most interested in the base64 encode/decode functions.

The data we are working with is base64 encoded arrays of floating point (32 bit) data. First challenge is to decode large (3-500 kbyte) base64 data strings. The second challenge is to convert the resulting varbinary array into arrays of floats.

Has anyone recompiled the dlls for 64 bit systems (we get the "unable to load dll" error if I try to use the distribution on a current system)? Or are there now a builtin base64 functions?

I have tried using the cast to XML and then calling the XML .value() functions.

DECLARE @data varchar(max), @XmlData xml, @vb varbinary(max)

SET @data = 'SGVsbG8gV29ybGQgIQ=='

SET @XmlData = CAST('<data>' + @data + '</data>' as xml)

SET @vb = @XmlData.value('(data)[1]', 'varbinary(max)')

SELECT @vb, CAST(@vb as varchar(max))

This works for small stirngs, but on large data strings, I get back NULL.

Thanks,

David

Mike C SSC-Insane Points: 23224 More actions · Answer 9

The first issue is probably trying to use the 32-bit dll's on a 64-bit system. Second issue is that binary to float conversion is not supported in SQL...

Ping me offline, I have a solution for you.

Thanks

Mike C

Mike C SSC-Insane Points: 23224 More actions · Answer 10

Better yet, just use the attached script. It has 4 CLR functions that do what you asked.

Enjoy,

Mike C

vhanda SSCrazy Points: 2240 More actions · Answer 11

A big thanks for posting this. A client's recent 2000/32 - 2008/64 migration missed an application call to the blowfish dll's and this saved our bacon this morning.

Khalid-334217 Grasshopper Points: 15 More actions · Answer 12

Hi

Does anyone have an example on how to base64encode and base64decode in SQL 2008 R2?

my code is as follows im using the 64 bit xp_blowfishdecrypt and xp_blowfishencrypt but 32 bit xp_base64encode is there a way around this

....

.....

DECLARE @text VARCHAR(255)

SET @key = '123456789'

EXEC master..xp_base64encode @key, @key OUTPUT

EXEC master..xp_blowfishdecrypt @name, @key, @text OUTPUT

SELECT @text as [Name]

I would really appreciate it if some one can help me on this as im in the process of migrating from SQL 2000 to SQL 2008

gshivaram 89152 Newbie Points: 5 More actions · Answer 13

i have a client who is sending data encrypted in 2005 database. we loaded it into 2008 database appreciate if you could provide dll's for 2008 sql server for 64 bit.

thank you

Khalid-334217 Grasshopper Points: 15 More actions · Answer 14

Go to page 14 of this thread

http://www.sqlservercentral.com/Forums/Topic199534-236-14.aspx

and you will see a zip file attachment from user : cygnussolutions

Thats what i use and they worked fine.

Quornstar SSC Rookie Points: 26 More actions · Answer 15

Hi

We are currently migrating from SQL 2000 to SQL2008R2 64x and are unable to install the dll's.

Earlier in this thread I have seen the recompiled 64bit versions of the Blowfish implementation - however we use the AES encryption and base64 encoding functionality.

Does anyone have the 64bit version of the AES/base64 related dlls that they can post a link for please?

--

Apologies I mis-posted the above into the wrong thread - we are using the 'SQL 2000 DBA Toolkit' as opposed to the 'SQL Encryption Toolkit' this thread is covering. I will post on that thread instead.

Thanks