Need Advice - encrypt data in transit

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 Encryption
http://msdn.microsoft.com/library/d...br />
6fu6.asp
INF: Network Encryption Available Using the Multi-Protocol Net Library
http://support.microsoft.com/defaul...kb;en-us;132224
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rog" wrote:

> 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 d
o
> this? Thanks !
>|||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
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Net-Library Encryption
> http://msdn.microsoft.com/library/d... />
s_6fu6.asp
> INF: Network Encryption Available Using the Multi-Protocol Net Library
> http://support.microsoft.com/defaul...kb;en-us;132224
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Rog" wrote:
>|||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/
"Rog" <Rog@.discussions.microsoft.com> wrote in message
news:1365028E-C6D4-4242-8439-DB066FA1095B@.microsoft.com...[vbcol=seagreen]
> 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
> "Mike Epprecht (SQL MVP)" wrote:
>