[SQL Server] (MSSQLSERVER) 服务因 找不到指定的模块。 服务特定错误而停止

状态:前些时间安装好SQL SERVER 2008。检查正常。之后安装VS2010和VS2012。昨天拷贝server上的数据到本地測试,结果发现能够连接远程。无法打开本地实样例。


第一步:查看配置管理工具:SQL SERVER 服务报错:远程调用失败。

百度搜索:VS2012安装后会安装SQL SERVER 2012 EXPRESS LOACLDB。和SQL SERVER 2008 冲突。故删除SQL SERVER 2012的组件。

检查服务发现起来了,高兴还是太早了SQL SERVER 等几个服务一直无法启动。查看windows日志


查看SQL SERVER 自带的日志文件:

2014-06-06 08:01:27.96 server         A self-generated certificate was successfully loaded for encryption.
2014-06-06 08:01:28.01 spid13s     The Service Broker protocol transport is disabled or not configured.
2014-06-06 08:01:28.03 spid13s     The Database Mirroring protocol transport is disabled or not configured.
2014-06-06 08:01:27.99 server         错误: 26055。严重性: 16,状态: 1。
2014-06-06 08:01:27.99 server         The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.
2014-06-06 08:01:28.03 spid13s     Service Broker manager has started.
2014-06-06 08:01:28.03 server         错误: 17182,严重性: 16,状态: 1。
2014-06-06 08:01:28.03 server         TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: 无法初始化 VIA 侦听器。 找不到指定的模块。


2014-06-06 08:01:28.07 server         错误: 17182,严重性: 16,状态: 1。
2014-06-06 08:01:28.07 server         TDSSNIClient initialization failed with error 0x7e, status code 0x1. Reason: 初始化失败,出现基础结构错误。

请检查曾经的错误。 找不到指定的模块。


2014-06-06 08:01:28.07 server         错误: 17826。严重性: 18,状态: 3。
2014-06-06 08:01:28.07 server         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.
2014-06-06 08:01:28.07 server         错误: 17120。严重性: 16,状态: 1。
2014-06-06 08:01:28.07 server         SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


VIA协议出错。干脆禁止了。

进入sql server configure manager,点开 Sql server 网络配置(非sql native client 配置),将VIA协议禁用。

再启动Sql Server服务,成功。



原文地址:https://www.cnblogs.com/tlnshuju/p/7121648.html