HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.securitytools » I need to use MD5 hashing, RSA encryption from SQL Server 2000...
Topic: I need to use MD5 hashing, RSA encryption from SQL Server 2000...
Hi all,
I need to digitally sign a string by usin MD5 hashing and RSA. All that
should be done from SQL Server 2000's Transact-SQL.
As long as I know SQL Server 2000 does not have support for this. I should
rely on third party libraries. Which one do you recomend? Is it any reliable
freeware dll I can use on a production server?
Thanks in advance
Sammy
Replies below ↓
Replies
Re: I need to use MD5 hashing, RSA encryption from SQL Server 2000...
Gotta say that I would be REALLY reticent about using a free dll on a
production server. Even if I had the source code and reviewed it for
security holes.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"SammyBar" <sammybar@gmail.com> wrote in message
news:uBwiGIbaIHA.1204@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I need to digitally sign a string by usin MD5 hashing and RSA. All that
> should be done from SQL Server 2000's Transact-SQL.
> As long as I know SQL Server 2000 does not have support for this. I should
> rely on third party libraries. Which one do you recomend? Is it any
> reliable freeware dll I can use on a production server?
>
> Thanks in advance
> Sammy
>
Re: I need to use MD5 hashing, RSA encryption from SQL Server 2000...
Here's a package with SHA hashing and symmetric encryption. Unfortunately no
RSA encryption or MD5. The source code is available on the same site so you
could download and check it for security holes, or use it as a basis for
creating your own SQL 2000 XPs to perform MD5 hashing and RSA encryption.
At the very least, the source code demonstrates how to write C/C++ extended
procedures and how to access the CryptoAPI from an XP.
The easiest thing to do would be to use the XP API to access the CryptoAPI
functionality. Ok, the *easiest* thing to do would be upgrade to SQL 2005
where all of this functionality is built in. But barring that, here's a
link:
http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/
"SammyBar" <sammybar@gmail.com> wrote in message
news:uBwiGIbaIHA.1204@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I need to digitally sign a string by usin MD5 hashing and RSA. All that
> should be done from SQL Server 2000's Transact-SQL.
> As long as I know SQL Server 2000 does not have support for this. I should
> rely on third party libraries. Which one do you recomend? Is it any
> reliable freeware dll I can use on a production server?
>
> Thanks in advance
> Sammy
>
Re: I need to use MD5 hashing, RSA encryption from SQL Server 2000
i found many sites that give md5 coding and decoding like
http://www.joomlaaa.com/md5-coding-decoding
i do not know how they can decode md5
anyone know a script to decode md5?
"Mike C#" wrote:
> Here's a package with SHA hashing and symmetric encryption. Unfortunately no
> RSA encryption or MD5. The source code is available on the same site so you
> could download and check it for security holes, or use it as a basis for
> creating your own SQL 2000 XPs to perform MD5 hashing and RSA encryption.
> At the very least, the source code demonstrates how to write C/C++ extended
> procedures and how to access the CryptoAPI from an XP.
>
> The easiest thing to do would be to use the XP API to access the CryptoAPI
> functionality. Ok, the *easiest* thing to do would be upgrade to SQL 2005
> where all of this functionality is built in. But barring that, here's a
> link:
> http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/
>
> "SammyBar" <sammybar@gmail.com> wrote in message
> news:uBwiGIbaIHA.1204@TK2MSFTNGP03.phx.gbl...
> > Hi all,
> >
> > I need to digitally sign a string by usin MD5 hashing and RSA. All that
> > should be done from SQL Server 2000's Transact-SQL.
> > As long as I know SQL Server 2000 does not have support for this. I should
> > rely on third party libraries. Which one do you recomend? Is it any
> > reliable freeware dll I can use on a production server?
> >
> > Thanks in advance
> > Sammy
> >
>
>
>
Re: I need to use MD5 hashing, RSA encryption from SQL Server 2000
"urcoder" <urcoder@discussions.microsoft.com> wrote in message
news:3C54B7BE-ECEE-4A50-A9D5-631C2F6C52FC@microsoft.com...
>i found many sites that give md5 coding and decoding like
> http://www.joomlaaa.com/md5-coding-decoding
> i do not know how they can decode md5
> anyone know a script to decode md5?
>
What do you mean by "decoding" MD5? MD5 is a one-way hash function, there's
no mathematical function to retrieve the original text. What they're doing
on this website, apparently, is storing a database of MD5 hash values and
the original text that produced them (about 60,000 of them apparently).
When you type in the MD5 hash value and hit "decode" they're doing a query
against the database. As an example, try their "decoder" with
CE114E4501D2F4E2DCEA3E17B546F339. This is a real MD5 hash value for real
text that I generated using another tool. The result is "not available",
since the original text I used to generate this hash code is not stored in
their database.