Re: installed ssl-certificate -> SQL-Server locked !

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 00:36:14 GMT

>From previous post:

"General question : how can we use a ssl-certificate for the web-service
together with a SQL-Server on the same machine? As far as I experienced now,
this is a dangerous experiment if no real MS-Experts are around!? Are there
manuals available?"

For SQL 2000 to use protocol encryption, SSL, the server must have a
Certificate issued to the FQDN name of the computer.
This would be the same if you were to setup IIS for SSL using Server
Authentication. So, if IIS and SQL are on the same machine,
then you just need one certificate. You can use the IIS tools to install
the certificate, since SQL doesn't supply any user tools.

I wrote the following two articles. and did the Webcast on setting up SSL
with SQL 2000.

316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898

276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553

324777 Support WebCast: Microsoft SQL Server 2000: How to Configure SSL
http://support.microsoft.com/?id=324777

Hope this helps,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • 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)
  • 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)
  • RE: How to enable 2-way SSL encryption
    ... This digital signature takes the form of a certificate ... SQL server 2000 implements SSL. ... Enable SSL Encryption for SQL Server 2000 with Certificate Server ...
    (microsoft.public.sqlserver.server)
  • Cannot Use Non-Administrator Account to Start SQL Server and Force Encryption
    ... I changed the service account of a named instance (product ... a certificate from a Microsft Certificate Server ... the SQL Service. ... SQL Server could not spawn FRunCM thread. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Cant con
    ... cannot open SQL Enterprise Manager. ... From the error message, it seems to be related to SSL and certifcate. ... Edit the registry on the SQL Server machine and make the following ...
    (microsoft.public.sqlserver.connect)