Re: SQL Server 2000 Encryption

It should stay disabled on the client. It's not a valid way
to check if the encryption is working - you need to use a
network sniffer to validate the encryption.

-Sue

On Wed, 22 Mar 2006 05:24:03 -0800, Brian P
<BrianP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Sue,

Thank you for the reply. When I am connected from my client to the SQL
Server that has encryption enabled, should my client connection properties
(from SQL Server Mgmt Studio) indicate Encrypted Yes? Currently, it says
Encrypted No. Is this indicator accurate or is it a valid way to determine
if communications are encryted?

Brian

"Sue Hoegemeier" wrote:

You enabled it globally using this method so you don't need
to worry about the client settings. If you want to enable it
for specific clients, you turn it off at the server and
enable encryption on the clients.
You would need to monitor the communication between the two
using a network sniffer like MS Network Monitor.
Check the following article for information on configuring
SSL:
How to enable SSL encryption for SQL Server 2000 or SQL
Server 2005 if you have a valid Certificate Server
http://support.microsoft.com/?id=276553

-Sue

On Tue, 21 Mar 2006 06:34:28 -0800, Brian P
<BrianP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have SQL Server 2000 Standard (SP4) running with encrypted communications
(I checked the the Force protocol encryption check box in the SQL Server
Network Utility). In order to do this, I setup a Certificate Server and a
certificate for the SQL Server.

What do we need to do on the client to insure communications are encrypted?
According to Microsoft, encryption should only be enabled on the server or
client, but not both. With that said, I have looked at connection properties
on my client (to the server) and have seen encryption set to No which
concerns me.

Is there an easy way to verify that communications are encrypted?

Thank you.



.

Relevant Pages

  • Re: Socket Server with Encryption help
    ... Before the client ... Authentication protocols are fiercely difficult to get right. ... by Needham and Schroeder "Using encryption for authentication in large ... Client connects into Server and Server accepts the connection. ...
    (microsoft.public.dotnet.security)
  • Question on client/server application
    ... (one will act as a simple TCP server and the other will be a simple ... TCP client). ... What is the simplest way for me to implement a secure connection ... There are plenty of encryption libraries out ...
    (comp.lang.pascal.delphi.misc)
  • RE: Implementing RSACryptoServiceProvider *and* JavaScript
    ... JavaScript: hashing, synchronous encryption, and asynchronous ... This will enable me to ensure security between the client ... Send these back to the server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Help Newbie..Upload file from SQL Server
    ... Enable SSL Encryption for SQL Server 2000 with Microsoft Management ... Steps to Use to Install a Certificate on a Server with Microsoft Management ... Steps to Enable Encryption for a Specific Client ...
    (microsoft.public.sqlserver.programming)
  • [NewbieQ] Feasability of MITM attack on SSH etc?
    ... I know very little about encryption, ... As I understand it, when an SSH client connects ... complete the two can commence encrypted communication with a reasonable ... and have that device pretend to be a server ...
    (sci.crypt)