asked on

Error while starting SQL Server 2008 as Service

I am trying to install SQL Server 2008, and trying to setup the service account as NT Authority Service. (Not Local Service).

When I complete installation, and try to start it as a Service, I get the following error:

Event Type:      Error
Event Source:      MSSQL$MSSQLSERVER2008
Event Category:      Server
Event ID:      17190
Date:            5/19/2010
Time:            7:00:24 PM
User:            N/A
Computer:      XXXXXXXXXXXXXXXXX
Description:
FallBack certificate initialization failed with error code: 15.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 26 43 00 00 10 00 00 00 &C......
0008: 1e 00 00 00 56 00 44 00 ....V.D.
0010: 56 00 53 00 32 00 39 00 V.S.2.9.
0018: 35 00 30 00 44 00 4f 00 5.0.D.O.
0020: 54 00 32 00 30 00 5c 00 T.2.0.\.
0028: 4d 00 53 00 53 00 51 00 M.S.S.Q.
0030: 4c 00 53 00 45 00 52 00 L.S.E.R.
0038: 56 00 45 00 52 00 32 00 V.E.R.2.
0040: 30 00 30 00 38 00 00 00 0.0.8...
0048: 00 00 00 00 ....

How do I remediate this problem? I have installed a new certificate, because I thought that the certificate for SQL Server was deleted. Please help!

Som Tripathi

Hi,

Your case matches with a problem mentioned in a blog -

http://www.jowie.com/blog/post/2008/05/13/SQL-Server-2005-fails-to-start-when-trying-to-use-a-self-signed-certificate.aspx

As a summary of the above -
(1) Delete the C:\Documents and Settings\NetworkService\Application Data\Microsoft\Crypto\RSA\S-1-5-20 and then try to restart service again.

NetworkService name might be Administrator, All Users or NetworkService. Please check your setting. But, most probably it should be NetworkService itself in your case.
(2) Check permission of NT Authority Service permission on the same directory. If there is any missing permission - grant it.

pzkhan

ASKER

Let me try and let you know

pzkhan

ASKER

I have delete the S-1-5-20 and then tried to restart the service ,
serviced did not started same old error

pzkhan

ASKER

I have unintalled SQL 2008 and reinstall again is same issue can some one help me out

here is error Message that i got it from SQL error Log

2010-05-21 17:21:18.00 Server Error: 17190, Severity: 16, State: 1.
2010-05-21 17:21:18.00 Server FallBack certificate initialization failed with error code: 15.
2010-05-21 17:21:18.00 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.

Error Message from eventviewer

Date:            5/21/2010
Time:            5:21:18 PM
User:            N/A
Computer:      XXXXXXXXXXXXXXX
Description:
FallBack certificate initialization failed with error code: 15.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 26 43 00 00 10 00 00 00 &C......
0008: 1f 00 00 00 42 00 41 00 ....B.A.
0010: 54 00 2d 00 32 00 39 00 T.-.2.9.
0018: 35 00 30 00 2d 00 56 00 5.0.-.V.
0020: 41 00 2d 00 44 00 42 00 A.-.D.B.
0028: 5c 00 4d 00 53 00 53 00 \.M.S.S.
0030: 51 00 4c 00 53 00 45 00 Q.L.S.E.
0038: 52 00 56 00 45 00 52 00 R.V.E.R.
0040: 32 00 30 00 30 00 38 00 2.0.0.8.
0048: 00 00 00 00 00 00 ......

ASKER CERTIFIED SOLUTION

Som Tripathi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial