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,严重性: 18,状态: 3。
2011-04-12 20:08:12.51 服务器 Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2011-04-12 20:08:12.51 服务器 错误: 17120,严重性: 16,状态: 1。
2011-04-12 20:08:12.51 服务器 SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
[解决办法]
我也遇见过 后面发现是数据库被压缩了
就是你在整理磁盘区间的时候被压缩了
还是建议重新安装 以免出现更多问题
[解决办法]
http://topic.csdn.net/u/20110412/20/66d087a2-9912-43f7-a8ee-e8453ea690a0.html?58014
[解决办法]
2011-04-12 20:08:12.51 服务器 Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
看起来是网络模块发生损坏了。先修复看看吧。
顺便也贴贴windows的事件日志看看。
[解决办法]