【原创】安装过程中出现SQL server服务无法启动
花费了一个周末,折腾了注册表、服务,重启了无数次。还是未能如愿装上SQL server 2005.心一横,备份了一下数据,重装系统。看重装系统后,能不能顺利装上SQL server 2005.令人悲伤的是,辛苦了很久,眼看着快要顺利装上了,又跳出了“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.
先留着,有空再把解决的方法贴上。