Solve the SharePoint "Search Service is offline" error

The moss error "the search service is offline" is displayed ". Specifically:

1. Choose "Management Center"> "Application Management"> "search service", and select "enable shared service providers for search, the crawling and propagation statuses are "the search service is offline ";

2. When you open shared service management> "Search"> "Search Settings", the following error occurs: "The Search Service is currently offline. Go to the Services page on the server in the SharePoint administration center to verify that the service is enabled ". This may also be caused by moving the indexer.

 

Solution Process:

1. It is suspected that the service is not started or the account permission is incorrect. Choose Administrative Tools> services to view the following two services:

Office Sharepoint Server search

Windows SharePoint Services search

Both services are started and the running account is already a domain administrator.

2. Check System Event Logs. Related errors found:

(1) The SQL database "wss_search_sps" cannot be found on the SQL server instance "192.168.10.250 ". The following contains other error messages from SQL Server.
The requested database wss_search_sps cannot be accessed ". Logon Failed. User 'supremetest \ spsadmin' Login Failed.

(2) job definition Microsoft. Sharepoint. Search. Administration. spsearchjobdefinition with ID 9388c075-0423-43fd-b23b-54dc6cb3f958 raises an exception. Detailed information is provided below.

The requested database wss_search_sps cannot be accessed ". Logon Failed. User 'supremetest \ spsadmin' Login Failed.

 

It seems to be a database problem.

3. Check the wss_search_sps database in the database and check that the database status is suspicious. Further Check related logs and find that an error occurs after a backup is restored. Modify the database:

Use master
Go
Sp_configure 'Allow updates', 1 reconfigure with override
Go
Alter database wss_search_sps set emergency
Go
Sp_dboption 'wss _ search_sps ', 'single user', 'true'
Go
DBCC checkdb ('wss _ search_sps ', 'repair _ allow_data_loss ')
Go
Alter database wss_search_sps Set Online
Go
Sp_configure 'Allow updates', 0 reconfigure with override
Go
Sp_dboption 'wss _ search_sps ', 'single user', 'false'
Go

 

After the command is executed, wss_search_sps is available.

4. Open "Administrative Tools"> "services" and restart the following two services to solve the problem.

Office Sharepoint Server search

Windows SharePoint Services search