首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

急在线求指点_sql2008服务器无法启动

2012-07-04 
急,在线求指导_sql2008服务器无法启动sql2008安装成功后,一起始是可以用的,可是后来不知怎么服务器启动不

急,在线求指导_sql2008服务器无法启动
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.


[解决办法]
我也遇见过 后面发现是数据库没压缩了 

就是你在整理磁盘区间的时候被压缩了

还是建议重新安装 以免出现更多问题
[解决办法]
我也建议重新安装.
[解决办法]
重新安装系统吧~
[解决办法]
应该是你的SQLSERVER的启动帐号权限不够
进入SQLSERVER服务配置工具,修改启动帐号为管理员帐号或者为localsystem.
再启动服务试下
[解决办法]
楼上的方法试过了吗?或者跟别的软件冲突了。
[解决办法]
重装吧

反正 也快
[解决办法]
有提示"2011-04-12 20:08:11.48 Server Authentication mode is WINDOWS-ONLY."
数据库验证模式只有windows验证,为何没有开SQL验证.
--> 预计更数据库服务的启动帐号有关,是否有修改过windows帐号密码?

热点排行