Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

New SQL and IIS install, Schannel Event ID: 36870

Posted on 2008-09-30
2
Medium Priority
?
2,352 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
[X]
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
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

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…
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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

688 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