The Microsoft Search service failed to start the solution. _mssql

1. Failure phenomenon

The error prompted to start with SQL Server Service Manager is as follows:

The error prompts you to start with the Service Manager are as follows:

2. Cause analysis

Follow " Five common Windows service startup problem debugging method " This article's plan idea carries on the elimination solution.

3. Solutions

For this error, a few key values are found when viewing the normal system services registry files. And check that some numeric data has been tampered with as follows:
Registry keys for Non-normal systems at 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" = "generates a Full-text index based on the content and attributes of structured and semi-structured data to enable fast word search of data"
[Hkey_local_machine\system\currentcontrolset\services\mssearch\performance]
"Perfinifile" = "Dsscntrs.ini"
"Last Counter" =dword:00001290
"Last Help" =dword:00001291
"The Counter" =dword:00001260
"The =dword:00001261"
[Hkey_local_machine\system\currentcontrolset\services\mssearch\enum]
"0" = "root\\legacy_mssearch\\0000"
"Count" =dword:00000001
"Nextinstance" =dword:00000001
The registry key for the normal system
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" = "generates a Full-text index based on the content and attributes of structured and semi-structured data to enable fast word search of data"
[Hkey_local_machine\system\currentcontrolset\services\mssearch\performance]
"Perfinifile" = "Dsscntrs.ini"
"Last Counter" =dword:00000ffe
"Last Help" =dword:00000fff
"The Counter" =dword:00000fce
"The =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

Try adding a normal system registry key to an unhealthy system. (because the contrast of the two system versions, the structure is the same, this time directly by importing Export registry keys for batch modification).