Solved

New SQL and IIS install, Schannel Event ID: 36870

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Following an example - removing duplicate strings 4 48
Can’t delete a file 14 136
CROSS APPLY 4 43
Determine what users accessed a directory or file in that directory? 4 42
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
A short film showing how OnPage and Connectwise integration works.

919 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now