Error:1067 the process terminated unexpectedly after service restart

Question

Hello guys i'm facing some trouble recently that i've never faced.I'm using WIndows XP sp2 on a dual core with MSSQL 2005 installed.
I got sql Express 2005 installed via Visual Studio and installed a named instance to it.
I've never noticed this till yesterday when i was trying to connect a java application.So i got the jdbc4 jar from microsoft and i wanted to know
the port number since i could not use 1433 to connect to the named instance.So i found a tutorial on microsoft support site to  allow remote connection and  assign port number to named instance.   so after those i restarted the service and i started having  "Could not start SQL SERVER (InstanceName) service on local computer.Error :1067 the process terminated unexpectedly".I've uninstalled the SQLExpress and tried but same thing.I got everything uninstalled and reintall them again.After the setup it complained that it cannot start the service so i clicked retry and all went well the service started.I went to the surface area configuration and allow remote connection and after that the service won't start.I did a search and end up reinstalling all .NEt framework through some hassle and manage to do it with the help of the blog .after restart it won't start. i've seen here some information but i don't really know where to look at in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and there are so many log files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. but i so found something in ERRORLOG.6
 2010-03-11 15:16:04.74 spid4s      Starting up database 'master'.
2010-03-11 15:16:06.60 spid4s      SQL Trace ID 1 was started by login "sa".
2010-03-11 15:16:06.74 spid4s      Starting up database 'mssqlsystemresource'.
2010-03-11 15:16:07.64 spid4s      Error: 15297, Severity: 16, State: 1.
2010-03-11 15:16:07.64 spid4s      The certificate, asymmetric key, or private key data is invalid.
2010-03-11 15:16:08.12 spid4s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
 but all other files are the same.Can somebody help me?

Answer 1

Can you get the complete content of the file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\Errorlog

---

Thanks, Leks

Answer 2

hello thanks for the fast response.The fact is i have ErrorLog and Errorlog.1-6.
here is the content of ErrorLog and it's similar to ErrorLog.1-4 except process ID and dates
2010-03-11 15:56:13.03 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
    Oct 14 2005 00:33:37
    Copyright (c) 1988-2005 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2010-03-11 15:56:13.03 Server      (c) 2005 Microsoft Corporation.
2010-03-11 15:56:13.03 Server      All rights reserved.
2010-03-11 15:56:13.03 Server      Server process ID is 4308.
2010-03-11 15:56:13.03 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-03-11 15:56:13.03 Server      This instance of SQL Server last reported using a process ID of 4744 at 3/11/2010 3:54:52 PM (local) 3/11/2010 3:54:52 PM (UTC). This is an informational message only; no user action is required.
2010-03-11 15:56:13.03 Server      Registry startup parameters:
2010-03-11 15:56:13.03 Server           -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-11 15:56:13.03 Server           -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-11 15:56:13.03 Server           -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-11 15:56:13.04 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-11 15:56:13.04 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-11 15:56:13.09 Server      Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2010-03-11 15:56:13.68 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-03-11 15:56:13.70 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
=============================================================================================
here is the content of Errorlog.6 and similar to Errorlog.5
2010-03-11 15:22:55.96 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
    Oct 14 2005 00:33:37
    Copyright (c) 1988-2005 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2010-03-11 15:22:55.96 Server      (c) 2005 Microsoft Corporation.
2010-03-11 15:22:55.96 Server      All rights reserved.
2010-03-11 15:22:55.96 Server      Server process ID is 464.
2010-03-11 15:22:55.96 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-03-11 15:22:55.96 Server      This instance of SQL Server last reported using a process ID of 216 at 3/11/2010 3:16:08 PM (local) 3/11/2010 3:16:08 PM (UTC). This is an informational message only; no user action is required.
2010-03-11 15:22:55.96 Server      Registry startup parameters:
2010-03-11 15:22:56.01 Server           -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-11 15:22:56.01 Server           -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-11 15:22:56.01 Server           -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-11 15:22:56.37 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-11 15:22:56.37 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-11 15:22:57.18 Server      Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2010-03-11 15:23:00.73 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-03-11 15:23:03.89 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-11 15:23:04.37 Server      The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality, please start this service.
2010-03-11 15:23:05.10 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-11 15:23:06.14 spid4s      Starting up database 'master'.
2010-03-11 15:23:08.67 spid4s      SQL Trace ID 1 was started by login "sa".
2010-03-11 15:23:08.85 spid4s      Starting up database 'mssqlsystemresource'.
2010-03-11 15:23:09.57 spid4s      Error: 15297, Severity: 16, State: 1.
2010-03-11 15:23:09.57 spid4s      The certificate, asymmetric key, or private key data is invalid.
2010-03-11 15:23:09.96 spid4s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

thanks for reading

Answer 3

Any comment ? Cause i have the same problem