SQL server cannot validate certificate

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

From: "Vassilios Christopoulos" <vassilis.christopoulos@intrasoft-intl.com>
Date: Sun, 28 Jul 2002 06:30:39 -0700

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: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Views
    ... you must understand that SQL Server 2000 does not support ... database data encryption as such. ... following method in the KB below to enhance the security. ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.programming)
  • Re: Protecting database from administrators
    ... >> there is no encryption while at rest it must still be secure. ... >> All the security MS has offered is weak. ... If it is attached to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE Security (aka users looking at my apps database)
    ... > I have been called in more than once to untangle all sorts of developer ... let's think about a genious tool, RAC by SQL Server MVP Thanh Ngo.. ... even if SQL Server encryption has been defeated... ... think to privacy protection for sensible data... ...
    (microsoft.public.sqlserver.msde)
  • Re: is WITH ENCRYPTION now safe in SQL2005?
    ... There are very dissenting opinions on that in the SQL Server community. ... you are in this situation you are quite happy that you can decrypt the ... How would a safe encryption method be implemented? ... private key, SQL Server must have access to that private key. ...
    (comp.databases.ms-sqlserver)