Re: SQL Server & SSL

From: Peter Borg (
Date: 10/31/02

From: "Peter Borg" <>
Date: Thu, 31 Oct 2002 08:30:41 -0800


I too am searching for a solution to this issue - I posted
the "how to generate a CSR from SQL" post yesterday. The
two articles you reference in you response to Antonio only
work if you are running a certificate server on your
internal network. I am trying to use a Verisign
certificate and need SQL to generate a CSR (Certificate
Signing Request). Are you aware of how to do this when the
certificate authority is a third-party vendor? The best
option I have found is to install IIS on the SQL Server,
use IIS to generate the CSR, and then uninstall IIS. This
method will allow for the correct fully qualified domain
name on the certificate. However, I am hoping for a
cleaner solution.

Thanks in advance for any help you can provide.

>-----Original Message-----
>Are these certificates the same you use for your web
>servers? Do you know if Verisign issues SSL certs for SQL
>>-----Original Message-----
>>A couple you may want to read:
>>HOW TO: Enable SSL Encryption for SQL Server 2000 with
>>Certificate Server
>>HOW TO: Enable SSL Encryption for SQL Server 2000 with
>>Microsoft Management Console
>>On Wed, 30 Oct 2002 07:25:59 -0800, "Antonio Tirado"
>><> wrote:
>>>Hi! I'm trying to install a SSL certificate for my SQL
>>>Server, to provide a secure DB over the internet to
>>>customers outside the building. Is there any link
>>>available that would describe the process just like the
>>>one that does it for IIS?}
>>>Thanks in advance.