I need some advice.
We need to encrypt data in transit between a fat client and SQL Server,
using either AES or 3DES encryption. We will have about 500 clients and
probably clustered servers. Can anyone give me advice on the best way to do
this? Thanks !
Net-Library Encryptio
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_c
s_6fu6.asp
INF: Network Encryption Available Using the Multi-Protocol Net Library
http://support.microsoft.com/default.aspx?scid=kb;en-us;132224

Signature
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
> I need some advice.
> We need to encrypt data in transit between a fat client and SQL Server,
> using either AES or 3DES encryption. We will have about 500 clients and
> probably clustered servers. Can anyone give me advice on the best way to do
> this? Thanks !
Rog - 27 Jul 2005 17:43 GMT
Thanks for the reply.
I'm not clear on what encryption algorithm SSL uses. Does it use AES or
3DES, or is it configurable so the algorithm can be specified?
-Rog
> Net-Library Encryption
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_c
s_6fu6.asp
[quoted text clipped - 7 lines]
> > probably clustered servers. Can anyone give me advice on the best way to do
> > this? Thanks !
Mike Epprecht (SQL MVP) - 27 Jul 2005 22:42 GMT
Hi
As SSL uses the OS's funcationality, the Certificate determines what is
used. You either need to use the Windows Certificate Authority or a 3rd
party CA like Verisign.
Most Certificate Authorities use RSA.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
> Thanks for the reply.
> I'm not clear on what encryption algorithm SSL uses. Does it use AES or
[quoted text clipped - 13 lines]
>> > to do
>> > this? Thanks !