Depends. If you use Windows Authentication, then the connection is
secured but the SQL query text and the returned results, if any, may not
be. If you use SQL Authenticated logins, then even the connection may
be insecure.

You can put a Server Certificate on the SQL Server and the connection
will be secured even if you do not specify encryption and use SSL.
However, if you want all communication to be secure, you need to use
SSL.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Ravi Verma
[mailto:mssqldba-ezmlmshield-x25654945.[Email address protected]
Sent: Thursday, July 29, 2004 1:09 AM
To: LazyDBA Discussion
Subject: Secure Connection

Hi



I am connecting to SQL Server through ADO from some other machine. Could
you
please tell me how much secure this connectivity is?



Ravi Verma







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page