Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 25th, 2007, 02:58 PM
Registered User
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Force Protocol Encryption

If I have "Force Protocol Encryption" turned off, then it should not need any certificate.
But when I see my event log always I found that:
"A self-generated certificate was successfully loaded for encryption."

After windows update the server reboots itself and it does not generate this certificate and my SQL server won't start.

Event Log:

FallBack certificate initialization failed with error code: 1.
Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

When I reboot the machine manually then it starts again.










Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the protocol to summit corrections to the tbroom BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 5 August 16th, 2006 12:48 PM
informal protocol implementation wilfordbrimley BOOK: Beginning Mac OS X Programming 1 June 3rd, 2006 12:55 PM
file protocol and non-IE browsers nemo-x HTML Code Clinic 1 July 19th, 2004 07:50 AM
Internet Transfer Protocol sporkman43 VB.NET 0 June 16th, 2004 08:45 AM
WebService - SOAP Protocol ksams .NET Web Services 1 January 29th, 2004 04:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.