Re: SQL server cannot validate certificate

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/30/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 29 Jul 2002 17:48:46 -0600

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

  • RE: Help Newbie..Upload file from SQL Server
    ... Enable SSL Encryption for SQL Server 2000 with Microsoft Management ... Steps to Use to Install a Certificate on a Server with Microsoft Management ... Steps to Enable Encryption for a Specific Client ...
    (microsoft.public.sqlserver.programming)
  • Encrypting off-site with certificates public key
    ... I thought it would be wise to use a certificate encryption scheme to allow ... Then the data is written into a varbinarycolumn on the central server ... For some reason the public key is generating a different algorithm on .NET ...
    (microsoft.public.sqlserver.security)
  • Re: Policy settings tool and username tokens (not x509)
    ... the wse setup tool is telling me "I'm making you give me an x509 server cert ... to do any encryption, something isn't right. ... > Having both client and server tokens allows the default WSE client to ... > require that the CN name in the certificate match the name of the ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: SSH-style public key authentication for web app login
    ... User obtains or generates a SSL certificate. ... implementations of RSA encryption written in javascript and PHP - so ... My first thought was for the server to generate a keypair when a user ... passwords. ...
    (comp.lang.php)
  • Re: SQL-Server startet nicht ...
    ... Because connection encryption is required, ... You should verify that the certificate is ... Check the SQL Server error log and the Windows event logs for information ...
    (microsoft.public.de.sqlserver)
Quantcast