Re: Encrypted JDBC connection from UNIX to a SQL Server 2000 Database Server

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 11/24/03 

Date: Mon, 24 Nov 2003 17:28:43 -0000

This article below has a good step by step (it refers to a
clustered environment but is relavent to non clustered also)
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26908

Here's a webcast on how to enable SSL
http://support.microsoft.com/default.aspx?scid=kb;en-us;324777

And here's a KB article that goes into detail about how to
enable SSL on the client side i.e. just for specific connections
and not all of them (which would be the case if you Force protocol
Encryption on the server)
http://support.microsoft.com/default.aspx?scid=kb;en-us;316898

My "top tips" for SSL would be

1) Make sure you request the certificate using the SQL Service account
and specify the FQDN of the server as the name on the certificate e.g.
SQLServername.domain.com
2) Make sure you install the certificate when logged in as the SQL service
account.

Some other articles
http://support.microsoft.com/default.aspx?scid=kb;en-us;318605
http://support.microsoft.com/default.aspx?scid=kb;EN-US;276553 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"carl" <anonymous@discussions.microsoft.com> wrote in message
news:318D4767-13AA-4D2A-AAE7-73396E6CD673@microsoft.com...
I have a SQL Server 2000 database server (enterprise edition on windows
2003) and an Application running on Unix AIX wants to connect into the
database using a JDBC connection that is SSL encrypted.
Does anyone have any suggestions or links to articles on this subject?.
Thanks in advance.
Carl

Relevant Pages

  • SQL Server SSL Enable...
    ... These are the steps I have made to enable SSL on SQL Server. ... I passed this request on to Microsoft Certificate ... able to login to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver)
  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... SQL Server Database Services 2005 ENU SP2 ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)