RE: SSL configuration for SQL server

From: Shailesh (shailesh_at_softhome.net)
Date: 01/29/04 

Date: Thu, 29 Jan 2004 10:53:43 -0800

Hi Kevin,

Thanks for replying. I have already read both the links
that you have sent. I have created a certifiacte and
installed it on my machine but somehow, when I go to
Internet explorer properties, and goto the certificte
content, I do not see this certificate in the "Personal"
section. I see it as issued in the Certification
Authority.

For these reaasons my SQL cannot see any certificate and
hence cannot start in the secure mode. So if I have them
configures as "Force encryption", the SQL server does not
start at all.

I think this has something to do with the certificate not
visible in the "Personal" tab of IE.

Thanks
Shailesh

>-----Original Message-----
>Hi Shailesh,
> There are basically three methods for getting the
certificates
>installed.
>
>1. Using MMC with an Enterprise CA & Active Directory
>2. Using web request to a StandAlone CA without Active
Directory.
>3. Using web request to a Third Party CA like Verisign
>
>It sounds like you really need to do either option 2 or 3.
>
>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
>
>
>Thanks,
>
>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: 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)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... When I clear the Certificate in the registry, I get the error that he is ... What you need to do to allow SQL Server to start successfully is to check ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)