Solved

New SQL and IIS install, Schannel Event ID: 36870

Posted on 2008-09-30
2
2,299 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Learn about cloud computing and its benefits for small business owners.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

679 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