Re: SQL server cannot validate certificate

From: Christopoulos Vassilios (vassilis.christopoulos@intrasoft-intl.com)
Date: 07/31/02 

From: "Christopoulos Vassilios" <vassilis.christopoulos@intrasoft-intl.com>
Date: Tue, 30 Jul 2002 22:22:58 -0700

Actually, we have gone through all related articles in KB.
We've checked multiple times our
installation/configuration according to those KB articles,
plus aplied all latest patches. But the problem is still
there.
So, we have started to believe that SSL does not work when
the SQL Server 2000 is running on a Win NT 4.0 server (as
I mentioned before, it works perfectly on W2K server).

Has anyone managed to run SQL Server 2000 on Win NT 4.0
with the "Force Protocol Encryption" option set? Did you
make any special configuration (which is probably not
described anywhere?)

Thanks

Vassilis

>-----Original Message-----
>You may want to check the steps under the topic: How SQL
>Server Verifies that a Certificate is Valid in the
following
>KB article:
>INF: How SQL Server Uses a Certificate When the Force
>Protocol Encryption Option is Set On
>http://support.microsoft.com/?scid=kb;en-us;Q318605
>
>-Sue
>
>On Sun, 28 Jul 2002 06:30:39 -0700, "Vassilios
>Christopoulos" <vassilis.christopoulos@intrasoft-intl.com>
>wrote:
>
>>
>>Dear all,
>>
>>I do have a problem to use SSL encryption on SQL Server
>>2000 running on Win NT 4.0 server.
>>More specifically, the SQL server CANNOT START when
>>the "Force Protocol Encryption" is set ON. The following
>>errors appeas in the Event log:
>>
>>----
>>17120 :
>>SQL Server could not spawn FRunCM thread.
>>
>>Error: 17826, Severity: 18, State: 1
>>Could not set up Net-Library 'SSNETLIB'.
>>
>>19015 :
>>Encryption requested but no valid certificate was found.
>>SQL Server terminating.
>>
>>Encryption requested but no valid certificate was found.
>>SQL Server terminating.
>>----
>>
>>Note that:
>>- A certificate has been obtained from a trusted
authority
>>and appears to be OK.
>>- We are running SQL Server 2000 SP2 with latest hotfix
>>applied (8.00.0655).
>>- The SQL server is running on a Windows NT Server 4.00
>>SP6a.
>>
>>Note that the problem does not appear when the SQL
server
>>is running on Windows 2000 Server (and the other
>>configuration remains the same + certificate obtained
from
>>same trusted authority). Does SSL encryption work on Win
>>NT 4.00 server? Any idea, what the problem might be?
>>
>>Thank you in advance
>>
>>Best regards,
>>
>>Vassilios Christopoulos
>>
>>
>>
>>
>>
>>
>
>.
>

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 cannot validate certificate
    ... | Sender: "Christopoulos Vassilios" ... | Subject: Re: SQL server cannot validate certificate ... | Has anyone managed to run SQL Server 2000 on Win NT 4.0 ... | with the "Force Protocol Encryption" option set? ...
    (microsoft.public.sqlserver.security)