Re: Secure connections using Query Analyzer

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/07/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Fri, 7 Feb 2003 19:26:00 -0000

SSL will encrypt all traffic between client and server apart from the
initial handshake. This includes SQL login information (if using SQL
authentication) and all queries + resultsets. I have sniffed this when
evaluating SSL and whilst before,all traffic was plain text and passwords
were weakly encrypted, with SSL you can't get anything useful. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dan Babington" <Dan.Babington@e-scapemedia.co.uk> wrote in message
news:e#IrXnrzCHA.1792@TK2MSFTNGP11...
> Hi,
>
> I'm new to this newsgroup, and have been directed here whilst trying to
find
> a way to securely connect Query Analyzer to a remote instance of SQL
Server
> 2000.
>
> I have read about using SSL encryption with SQL Server 2000 which
"encrypts
> all data transmitted between an application computer and a SQL Server
> instance".
>
> What I'm therefore assuming is that when you enable SSL encryption, that
> Query Analyzer connections will indeed be encrypted, I just can't find
> anywhere that says this in so many words.
>
> I was wondering if anybody on in this newsgroup can confirm that this is
the
> case?
>
> Thanks in advance,
> Dan
>
>
>
>
>

Relevant Pages

  • Re: encrypt password for webservices
    ... When you say about limitation of IIS/SLL (I assume it should be SSL) ... > 3) Requests can be multi-threaded, and some requests can even be droped if ... which allows the server to find appropriate EncryptionKey ... > encryption. ...
    (microsoft.public.dotnet.security)
  • Re: No SSL Should I care?
    ... server issue or keep using Verizon's Wireless Sync which does use AES ... I was going to use activesync over wifi in europe since my 730 won't work ... and I couldn't get that to work using SSL either. ... that provides SSl encryption between my server and the verizon web ...
    (microsoft.public.pocketpc.activesync)
  • Help with SSL for Exchange 2003
    ... I hope somebody could help me with SSL. ... and Outlook, however, I cannot get SMTP to work properly. ... If I select SSL encryption the error I get is: "Your server does not ...
    (microsoft.public.exchange.admin)
  • Re: SSIS as part of scheduled job fails
    ... might not have Encryption support, but it shouldn't be trying to use SQL ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: Can encryrpted packets be cracked by middle man?
    ... But when you add that "someone who has complete control ... ssl connection to the proxy server which then communicates with the web ... server which could be either http or https as is that possibility with ISA. ... > This is a question about how secure encryption is. ...
    (microsoft.public.security)