Solved

New SQL and IIS install, Schannel Event ID: 36870

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 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

10 Experts available now in Live!

Get 1:1 Help Now