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.
提示如下：
请求失败或服务未及时响应，有关详细信息，请参见事件日志或其他适用的错误日志（附图）
以下是错误日志文件内容
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服务配置工具,修改启动帐号为管理员帐号或者为localsystem.
再启动服务试下
数据库验证模式只有windows验证,为何没有开SQL验证.
--> 预计更数据库服务的启动帐号有关,是否有修改过windows帐号密码?
这是因为修改了sqlserver服务的登录身份，无意中将登录身份修改为localservice或其他的了，导致无法再改回去。
解决方法：在控制面板-服务中，将sql2008的服务的登录用户改为“系统登录”，重新启动服务，就可以了。