当前位置: 首页 > 图文教程 > 数据库 > MSSQL > Microsoft Search 服务无法启动 解决办法.

MSSQL
sql server的保留关键字
SQL2000 关于 Java JDBC 驱动的安装和设定
SQL Server2005数据库查询中使用CTE
如何整理SQL Server输入数据
SQL优化34条
怎样用SQL服务器调节器收集重要信息
黑客经验谈 MSSQLSA权限入侵的感悟
SQL Server企业管理器和查询分析器简介
SQL Server开发人员应聘常被问的问题
限制系统管理员对SQL Server进行访问
升级到SQL Server 2005之后转换登录
SQL Server 2000中监控失败的登录尝试
MSSQL移动到新服务器出现不匹配问题
让你见识一下SQL Server口令的脆弱性
全面调整SQL Server的硬件性能计划
SQL SERVER数据导成INSERT
SQL Server中保护数据的安全选项
防范SQL注入攻击的新办法
SQL Server数据库安全管理机制详解
妙用SQL子查询来从子表里删除数据

MSSQL 中的 Microsoft Search 服务无法启动 解决办法.


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-09-13   浏览: 168 ::
收藏到网摘: n/a

尝试用正常系统的注册表项添加到非正常系统中去。(因为对比的两个系统版本、结构相同,所此次就直接通过导入导出注册表项进行批量修改)。

1.故障现象

通过 SQL Server 服务管理器 启动出错提示如下:

通过服务管理器启动出错提示如下:

2.原因分析


安照《五种常见Windows服务启动问题的排错方法》这篇文章的方案思路进行排除解决。

3.解决办法

对于本次出现的错误,在查看正常系统服务注册表文件时发现少几个项值。并检查一些数值数据是否被篡改如下:
BEGIN 下为非正常系统的注册表
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH]
"Type"=dword:00000020
"Start"=dword:00000002
"ErrorControl"=dword:00000001
"DisplayName"="Microsoft Search"
"ImagePath"=hex(2):22,00,43,00,3a,00,5c,00,50,00,72,00,6f,00,67,00,72,00,61,00,\
6d,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,43,00,6f,00,6d,00,6d,00,6f,\
00,6e,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,53,00,79,00,73,00,74,00,\
65,00,6d,00,5c,00,4d,00,53,00,53,00,65,00,61,00,72,00,63,00,68,00,5c,00,42,\
00,69,00,6e,00,5c,00,6d,00,73,00,73,00,65,00,61,00,72,00,63,00,68,00,2e,00,\
65,00,78,00,65,00,22,00,00,00
"Description"="基于结构化和半结构化数据的内容以及属性生成全文索引,以便可以对数据进行快速的单词搜索"
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH\Performance]
"PerfIniFile"="DssCntrs.ini"
"Last Counter"=dword:00001290
"Last Help"=dword:00001291
"First Counter"=dword:00001260
"First Help"=dword:00001261
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH\Enum]
"0"="Root\\LEGACY_MSSEARCH\\0000"
"Count"=dword:00000001
"NextInstance"=dword:00000001
下为正常系统的注册表
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH]
"Type"=dword:00000020
"Start"=dword:00000002
"ErrorControl"=dword:00000001
"ImagePath"=hex(2):22,00,43,00,3a,00,5c,00,50,00,72,00,6f,00,67,00,72,00,61,00,\
6d,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,43,00,6f,00,6d,00,6d,00,6f,\
00,6e,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,53,00,79,00,73,00,74,00,\
65,00,6d,00,5c,00,4d,00,53,00,53,00,65,00,61,00,72,00,63,00,68,00,5c,00,42,\
00,69,00,6e,00,5c,00,6d,00,73,00,73,00,65,00,61,00,72,00,63,00,68,00,2e,00,\
65,00,78,00,65,00,22,00,00,00
"DisplayName"="Microsoft Search"
"DependOnService"=hex(7):52,00,50,00,43,00,53,00,53,00,00,00,4e,00,54,00,4c,00,\
4d,00,53,00,53,00,50,00,00,00,00,00
"DependOnGroup"=hex(7):00,00
"ObjectName"="LocalSystem"
"Description"="基于结构化和半结构化数据的内容以及属性生成全文索引,以便可以对数据进行快速的单词搜索"
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH\Performance]
"PerfIniFile"="DssCntrs.ini"
"Last Counter"=dword:00000ffe
"Last Help"=dword:00000fff
"First Counter"=dword:00000fce
"First Help"=dword:00000fcf
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH\Security]
"Security"=hex:01,00,14,80,b8,00,00,00,c4,00,00,00,14,00,00,00,30,00,00,00,02,\
00,1c,00,01,00,00,00,02,80,14,00,ff,01,0f,00,01,01,00,00,00,00,00,01,00,00,\
00,00,02,00,88,00,06,00,00,00,00,00,14,00,fd,01,02,00,01,01,00,00,00,00,00,\
05,12,00,00,00,00,00,18,00,ff,01,0f,00,01,02,00,00,00,00,00,05,20,00,00,00,\
20,02,00,00,00,00,14,00,8d,01,02,00,01,01,00,00,00,00,00,05,04,00,00,00,00,\
00,14,00,8d,01,02,00,01,01,00,00,00,00,00,05,06,00,00,00,00,00,14,00,00,01,\
00,00,01,01,00,00,00,00,00,05,0b,00,00,00,00,00,18,00,fd,01,02,00,01,02,00,\
00,00,00,00,05,20,00,00,00,23,02,00,00,01,01,00,00,00,00,00,05,12,00,00,00,\
01,01,00,00,00,00,00,05,12,00,00,00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH\Enum]
"0"="Root\\LEGACY_MSSEARCH\\0000"
"Count"=dword:00000001
"NextInstance"=dword:00000001
END
尝试用正常系统的注册表项添加到非正常系统中去。(因为对比的两个系统版本、结构相同,所此次就直接通过导入导出注册表项进行批量修改)。