Search Host Controller Service stuck in Starting SharePoint 2016

Question

I have tried to Stop it and again start using Powershell and through Central Admin. No luck in Powershell and by Central Admin I got Timeout Error with Correlation ID. When checking this in ULS log same error message for Timeout.

At the same time below is error Details from Event Viewer:

Insufficient SQL database permissions for user 'Name: domain\AccountName ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'InstanceName'. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_getObject', database 'SharePoint_Config', schema 'dbo'.

Also the below error for SSA:

Unable to retrieve topology component health states. This may be because the admin component is not up and running.

Answer 1

Sounds like you need to grant the execute permission to the user (or a group that they a part of) for the stored procedure in question:

USE service\account; GRANT EXEC ON dbo.DATABASE TO PUBLIC

Answer 2

You can give execute permission for “WSS_Content_Application_Pools” user in the relevant database stored procedure.

Open Microsoft SQL server managent studio, in the 'SharePoint_Config' database->Programmability ->Stored Procedures-> right click “dbo.proc_ getObject”-> Properties->Permissions. Select ‘WSS_Content_Application_Pools’ in the Users or roles section, and grant ‘Execute’ permission in the Explicit section.