日期:2014-05-17  浏览次数:20770 次

sql 2008配置管理器的服务器无法启动(在线等待)
sql2008安装成功后,一起始是可以用的,可是后来不知怎么服务器启动不了
提示如下:
请求失败或服务未及时响应,有关详细信息,请参见事件日志或其他适用的错误日志(附图)




以下是错误日志文件内容
2011-04-12 20:08:11.48 Server Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86) 
Sep 16 2010 20:09:22 
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2011-04-12 20:08:11.48 Server (c) 2005 Microsoft Corporation.
2011-04-12 20:08:11.48 Server All rights reserved.
2011-04-12 20:08:11.48 Server Server process ID is 3124.
2011-04-12 20:08:11.48 Server Authentication mode is WINDOWS-ONLY.
2011-04-12 20:08:11.48 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server2008\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-04-12 20:08:11.48 Server This instance of SQL Server last reported using a process ID of 136 at 2011-4-12 19:38:04 (local) 2011-4-12 11:38:04 (UTC). This is an informational message only; no user action is required.
2011-04-12 20:08:11.48 Server Registry startup parameters: 
-d C:\Program Files\Microsoft SQL Server2008\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server2008\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server2008\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-04-12 20:08:11.49 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-04-12 20:08:11.49 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2011-04-12 20:08:12.05 服务器 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.
2011-04-12 20:08:12.12 服务器 Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-04-12 20:08:12.14 spid7s Starting up database 'master'.
2011-04-12 20:08:12.27 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-04-12 20:08:12.29 spid7s SQL Trace ID 1 was started by login "sa".
2011-04-12 20:08:12.29 spid7s Starting up database 'mssqlsystemresource'.
2011-04-12 20:08:12.30 spid7s The resource database build version is 10.00.4000. This is an informational message only. No user action is required.
2011-04-12 20:08:12.44 spid10s Starting up database 'model'.
2011-04-12 20:08:12.44 spid7s Server name is 'XX20110412'. This is an informational message only. No user action is required.
2011-04-12 20:08:12.44 spid7s 信息: 找不到支持全文的语言。
2011-04-12 20:08:12.44 spid7s Starting up database 'msdb'.
2011-04-12 20:08:12.51 服务器 错误: 17190,严重性: 16,状态: 1。
2011-04-12 20:08:12.51 服务器 Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
2011-04-12 20:08:12.51 服务器 Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2011-04-12 20:08:12.51 服务器 错误: 17182,严重性: 16,状态: 1。
2011-04-12 20:08:12.51 服务器 TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: 无法初始化 SSL 支持。 找不到对象或属性。

2011-04-12 20:08:12.51 服务器 错误: 17182,严重性: 16,状态: 1。
2011-04-12 20:08:12.51 服务器 TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: 初始化失败,出现基础结构错误。请检查以前的错误。 找不到对象或属性。

2011-04-12 20:08:12.51 服务器 错误: 17826,