sqlserver and certificates.

From: John Michale (polite1974_at_hotmail.com)
Date: 04/30/03 

Date: Wed, 30 Apr 2003 06:10:48 -0700

we need to establish connection to sqlserver 2000 from
clients having windows 2000 or windows nt. We need to do
establish ssl connection.for this reason, i installed
certificate services on my server. Note that i have
advance server 2k with sqlserver and iis. I also installed
client certificates on the virutal machine and on a client
machine. The sqlserver is running fine. We can configure
sqlserver in a way that we need to pass parameter to
decide if we use ssl or not. e.g ConnectString
= "SERVER=mydataserver;DRIVER=SQL
Server;Address=192.0.0.27;uid=abc;pwd=xyz;
Network=DBMSSOCN;DATABASE=NorthWind;Integerated
Security=SSPI"
The connection establishes with or without specifying
sspi. How can i see the encryption is really taking place.
I used network monitor but cant see any sql string.

Relevant Pages

  • Re: Challenge/response and nonces
    ... This server has to handle many simultaneous connections (with only ... small amounts of data on any particular connection) and TCP connections ... this is actually SSL operating ... the client responds with F, where K is the shared key and F ...
    (sci.crypt)
  • Anonymous "RPC over HTTP" with SSL
    ... connection between an RPC server and a client WITHOUT SSL (= traffic from ... client to RPC Proxy is HTTP to port 80). ...
    (microsoft.public.platformsdk.security)
  • Erratic SSL Error: Could not establish secure channel for SSL/TLS
    ... I use SSL to secure the connection. ... My client application ... makes thousands of calls to the web services each day, ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Doesnt anyone else use SSL?
    ... network connectivity the client has. ... SSL is an encrypted tunnel around a TCP/IP connection. ... > certificate) -->WebServer on port 81 with no SSL certificate ...
    (microsoft.public.inetserver.iis.security)
  • secure communication with sqlserver2000
    ... I need to connect to sqlserver with the option to user ... encryption or not. ... use ssl to secure communication with sqlserver ... The document says to establish connection i have to use ...
    (microsoft.public.sqlserver.security)