Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Security / July 2005

Tip: Looking for answers? Try searching our database.

Need Advice - encrypt data in transit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rog - 27 Jul 2005 15:15 GMT
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 !
Mike Epprecht (SQL MVP) - 27 Jul 2005 16:37 GMT
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 !
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.