Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

New SQL and IIS install, Schannel Event ID: 36870

Posted on 2008-09-30
2
2,292 Views
Last Modified: 2012-05-05
I just installed SQL 2005 Std on Windows 2003.  Of course there was a warning about IIS, so I cancelled the SQL install and installed IIS first.

I'm just trying to clean up the event view and under System event log I get:

Event Type:      Error
Event Source:      Schannel
Event Category:      None
Event ID:      36870
Date:            9/30/2008
Time:            2:05:50 PM
User:            N/A
Computer:      SAMEDAY2
Description:
A fatal error occurred when attempting to access the SSL server credential private key. The error code returned from the cryptographic module is 0x80090016.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Under Application log at the same time I get:

Event Type:      Information
Event Source:      MSSQL$SDS
Event Category:      (2)
Event ID:      26010
Date:            9/30/2008
Time:            2:05:50 PM
User:            N/A
Computer:      SAMEDAY2
Description:
The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9a 65 00 00 0a 00 00 00   še......
0008: 0d 00 00 00 53 00 41 00   ....S.A.
0010: 4d 00 45 00 44 00 41 00   M.E.D.A.
0018: 59 00 32 00 5c 00 53 00   Y.2.\.S.
0020: 44 00 53 00 00 00 00 00   D.S.....
0028: 00 00                     ..      


and also...

Event Type:      Information
Event Source:      MSSQL$SDS
Event Category:      (2)
Event ID:      26018
Date:            9/30/2008
Time:            2:05:51 PM
User:            N/A
Computer:      SAMEDAY2
Description:
A self-generated certificate was successfully loaded for encryption.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: a2 65 00 00 0a 00 00 00   ¢e......
0008: 0d 00 00 00 53 00 41 00   ....S.A.
0010: 4d 00 45 00 44 00 41 00   M.E.D.A.
0018: 59 00 32 00 5c 00 53 00   Y.2.\.S.
0020: 44 00 53 00 00 00 00 00   D.S.....
0028: 00 00                     ..      


Is this ok or is it indicative of a problem.

I did create a new domain user for use as the service account instead of local system, if that makes any difference.



0
Comment
Question by:Brian_MB
2 Comments
 
LVL 10

Expert Comment

by:santhoshu
ID: 22624168
0
 

Accepted Solution

by:
Brian_MB earned 0 total points
ID: 22746332
Doesn't seem to be affecting anything.  I believe it's probably because no certificate is installed, so I guess I'll ignore it for now.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question