启动MSSQLSERVER服务时报错：

     本地计算机上的MSSQLSERVER服务启动后又停止了。一些服务自动停止，如果它们没有什么可做的，例如“性能日志和警报”服务。

打开日志查看器开始看日志：

       SQL Server 无法生成 FRunCM 线程。请查看 SQL Server 错误日志和 Windows 事件日志，获取有关可能发生的相关问题的信息。

       由于网络库中存在内部错误，所以无法启动网络库。要确定原因，请查看错误日志中紧位于此错误之前的那些错误。

        TDSSNIClient 初始化失败，出现错误 0x7e，状态代码 0x1。

接着查看SQL日志 (MSSQL.1\MSSQL\LOG)

2011-04-07 10:35:39.15 Server      Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86)
 Oct 14 2005 00:33:37
 Copyright (c) 1988-2005 Microsoft Corporation
 Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2011-04-07 10:35:39.15 Server      (c) 2005 Microsoft Corporation.
2011-04-07 10:35:39.15 Server      All rights reserved.
2011-04-07 10:35:39.15 Server      Server process ID is 5400.
2011-04-07 10:35:39.15 Server      Logging SQL Server messages in file ‘D:\sql\MSSQL.1\MSSQL\LOG\ERRORLOG’.
2011-04-07 10:35:39.15 Server      This instance of SQL Server last reported using a process ID of 6068 at 2011-4-7 10:34:02 (local) 2011-4-7 2:34:02 (UTC). This is an informational message only; no user action is required.
2011-04-07 10:35:39.15 Server      Registry startup parameters:
2011-04-07 10:35:39.15 Server        -d D:\sql\MSSQL.1\MSSQL\DATA\master.mdf
2011-04-07 10:35:39.15 Server        -e D:\sql\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-04-07 10:35:39.15 Server        -l D:\sql\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-04-07 10:35:39.17 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-04-07 10:35:39.17 服务器         Detected 2 CPUs. This is an informational message; no user action is required.
2011-04-07 10:35:39.37 服务器         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-07 10:35:39.39 服务器         Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2011-04-07 10:35:39.39 服务器         The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality, please start this service.
2011-04-07 10:35:39.39 服务器         Database Mirroring Transport is disabled in the endpoint configuration.
2011-04-07 10:35:39.40 spid5s      Starting up database ‘master’.
2011-04-07 10:35:39.59 spid5s      SQL Trace ID 1 was started by login “sa”.
2011-04-07 10:35:39.60 spid5s      Starting up database ‘mssqlsystemresource’.
2011-04-07 10:35:39.76 spid5s      Server name is ‘NQ’. This is an informational message only. No user action is required.
2011-04-07 10:35:39.76 spid9s      Starting up database ‘model’.
2011-04-07 10:35:39.81 服务器         The certificate was successfully loaded for encryption.
2011-04-07 10:35:39.81 服务器         错误: 17182，严重性: 16，状态: 1。
2011-04-07 10:35:39.81 服务器         TDSSNIClient initialization failed with error 0x7e, status code 0x60.
2011-04-07 10:35:39.81 服务器         错误: 17182，严重性: 16，状态: 1。
2011-04-07 10:35:39.81 服务器         TDSSNIClient initialization failed with error 0x7e, status code 0x1.
2011-04-07 10:35:39.81 服务器         错误: 17826，严重性: 18，状态: 3。
2011-04-07 10:35:39.81 服务器         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-07 10:35:39.81 服务器         错误: 17120，严重性: 16，状态: 1。
2011-04-07 10:35:39.81 服务器         SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

可以判定，可能是以下几个问题：

1、IP地址配置不正确：

打开 \Microsoft SQL Server 2005\配置工具\下的SQL Server Configuration Manager，选择MSSQLSERVER协议, 然后双击右边窗口的TCP/IP，在弹出窗口中检查IP配置。

一般默认的IP2是：127.0.0.1，如果第一个IP地址的端口1433端口telnet不通的话，服务无法启动。您可以将127.0.0.1放在IP1上，那么不管IP2的端口是否能telnet通，服务都能够正常启动。您也可以将IP1设置为当前机器的IP地址，并保证该IP地址的端口能够ping通。

2、可能是因为VIA协议启用造成的。解决方法如下：

打开 \Microsoft SQL Server 2005\配置工具\下的SQL Server Configuration Manager，选择mssqlserver协议, 然后右边窗口有个VIA，点击右键禁用它，点击“确定”即可。这时候再启动sqlserver服务即可！

另外，管理员密码修改也会造成sqlserver服务无法启动。解决方法如下：

打开 \Microsoft SQL Server 2005\配置工具\下的SQL Server Configuration Manager，在MSSQLSERVER服务属性中，修改以哪个账号来启动服务。

我机器启动不了服务的原因就是启用了 “VIA”服务，禁用后，OK了。

（VIA: 是SQL Server的一个连接协议，全名Virtual Interface Architecture,中文名是虚拟接口架构。搜索相关资料后说，via协议最好不要启动，类似于虚拟设备，特像vpn原理，不知道这样说对不对，总之排错的时候注意下这些）