【原创】安装过程中出现SQL server服务无法启动

时间:2022-01-06 17:14:12

花费了一个周末,折腾了注册表、服务,重启了无数次。还是未能如愿装上SQL server 2005.心一横,备份了一下数据,重装系统。看重装系统后,能不能顺利装上SQL server 2005.令人悲伤的是,辛苦了很久,眼看着快要顺利装上了,又跳出了“SQL server服务无法启动”这样的弹出框。先留着这问题,有空再来解决。

以下是安装过程中弹出的画面:

【原创】安装过程中出现SQL server服务无法启动

以下便是错误日志:

 2014-06-22 23:30:47.70 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 6.2 (Build 9200: )

2014-06-22 23:30:47.70 Server      (c) 2005 Microsoft Corporation.
2014-06-22 23:30:47.70 Server      All rights reserved.
2014-06-22 23:30:47.70 Server      Server process ID is 7936.
2014-06-22 23:30:47.70 Server      Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2014-06-22 23:30:47.70 Server      This instance of SQL Server last reported using a process ID of 7140 at 2014/6/22 23:29:20 (local) 2014/6/22 15:29:20 (UTC). This is an informational message only; no user action is required.

2014-06-22 23:30:47.70 Server      Registry startup parameters:
2014-06-22 23:30:47.70 Server        -d E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2014-06-22 23:30:47.70 Server        -e E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2014-06-22 23:30:47.70 Server        -l E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2014-06-22 23:30:47.70 Server      Command Line Startup Parameters:
2014-06-22 23:30:47.70 Server        -m SqlSetup
2014-06-22 23:30:47.70 Server        SqlSetup
2014-06-22 23:30:47.70 Server        -Q
2014-06-22 23:30:47.70 Server        -q Chinese_PRC_CI_AS
2014-06-22 23:30:47.70 Server        -T 4022
2014-06-22 23:30:47.70 Server        -T 3659
2014-06-22 23:30:47.70 Server        -T 3610
2014-06-22 23:30:47.70 Server        -T 4010

2014-06-22 23:30:47.73 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-06-22 23:30:47.73 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2014-06-22 23:30:47.76 Server      Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2014-06-22 23:30:47.86 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.

2014-06-22 23:30:47.87 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2014-06-22 23:30:48.90 Server      Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2014-06-22 23:30:48.90 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2014-06-22 23:30:48.90 spid5s      Warning ******************
2014-06-22 23:30:48.90 spid5s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2014-06-22 23:30:48.90 spid5s      Error: 15507, Severity: 16, State: 1.
2014-06-22 23:30:48.90 spid5s      A key required by this operation appears to be corrupted.

 

先留着,有空再把解决的方法贴上。