Re: SQL Server & SSL

From: Peter Borg (peter@grouptech.com)
Date: 10/31/02 

From: "Peter Borg" <peter@grouptech.com>
Date: Thu, 31 Oct 2002 08:30:41 -0800

Sue,

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.

Peter
>-----Original Message-----
>Are these certificates the same you use for your web
>servers? Do you know if Verisign issues SSL certs for SQL
>Server?
>
>
>
>
>>-----Original Message-----
>>A couple you may want to read:
>>HOW TO: Enable SSL Encryption for SQL Server 2000 with
>>Certificate Server
>>http://support.microsoft.com/?scid=kb;en-us;Q276553
>>
>>HOW TO: Enable SSL Encryption for SQL Server 2000 with
>>Microsoft Management Console
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q316898
>>
>>-Sue
>>
>>On Wed, 30 Oct 2002 07:25:59 -0800, "Antonio Tirado"
>><atirado@vepica.com> 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.
>>>
>>
>>.
>>
>.
>

Relevant Pages

  • Re: ssl renewal questions
    ... Just on the server which I guess explains the clients being able to ... the certificate is invalid ... >> but connections continue to be encrypted and restarts of sql ... >>> appears that I had to stop and restart the sql process to get certs ...
    (microsoft.public.sqlserver.security)
  • Re: ssl renewal questions
    ... > a year on a test server and check the certificate using the ... > certificates mmc snap-in, the certificate shows up as expired ... > but connections continue to be encrypted and restarts of sql ... If a cert expires, do subsequent ...
    (microsoft.public.sqlserver.security)
  • Re: Web Server to SQL Server
    ... You will need a certificate for your SQL Server ... Here's a webcast on how to enable SSL ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Encryption
    ... also that you install the certificate when logged in as the SQL Service ... Jasper Smith (SQL Server MVP) ... "Robert Abela" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?
    ... "Note that, in all cases, SQL Server sends its server authentication ... this occurs even when neither the server nor the client requires ... > using the Query Analyzer tool from a machine without the certificate ...
    (microsoft.public.sqlserver.server)