SharePoint Search Service Application Errors: The search application ‘Search Service Application’ on server did not finish loading. View the event logs on the affected server for more information

If you get this (annoying) error then a possible solution is to check if your account which you use to administrate(or use the search service application) on the SQL Server side.

The search application ‘Search Service Application’ on server did not finish loading. View the event logs on the affected server for more information

Open Your SQL Server Management studio. Go to your Security folder, then Logins and then double click on your account which needs search privileges. Then go to user mapping in the new window and check that the following search service databases has privileges to your account and that the account has the “SPSearchDBAdmin” rights assigned:

Search Databases:

SharePoint_Service_Search

SharePoint_Service_Search_AnalyticsReportingStore

SharePoint_Service_Search_CrawlStore

SharePoint_Service_Search_LinksStore

Search Service Application Error

Search Service Application Error

Advertisements

2 thoughts on “SharePoint Search Service Application Errors: The search application ‘Search Service Application’ on server did not finish loading. View the event logs on the affected server for more information

  1. You saved my life, thanks

  2. Hello. I am troubleshooting this issue. I see that my service account has the rights assigned like you show in the picture, but instead of having “dbo” in the default schema, it has the DOMAIN\USERNAME of said service account. Is this correct?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s