none
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.

    jeudi 5 juillet 2018 07:29

Toutes les réponses

  • Hi NikhilP005,

    For your issue, firstly, make sure the database access account is assigned correctly and then verify the account has correct permission in SQL Server:

    • In SQL Server Management Studio, in the Object Explorer navigation pane, expand the Security node, and then click the Logins node.
    • Check if the account exists. If exists, expand the 'SharePoint_Config’ database, open the Security node, and then click Roles.
    • Expand the Database Roles node, right-click db_owner, and select Properties.
    • In the Database Roles Properties dialog box, check whether the database access account is in the Members of this role list. If the account is not listed, click Add.

    If the issue exists, follow the steps below:

    • Expand your SharePoint Configuration database 'SharePoint_Config' and navigate to ‘proc_ getObject’ under Programmability ->Stored Procedures.
    • Right-click ‘proc_ getObject’ and choose Properties.
    • Click on Permission on the left launch. Select the Search button and browse for ‘WSS_Content_Application_Pools’.
    • Provide ‘Execute’ permissions for ‘WSS_Content_Application_Pools’.

    Reference:

    https://social.technet.microsoft.com/Forums/en-US/a0d08e98-1fd6-42cf-b738-6ba3df082210/search-account-got-insufficient-sql-database-permissions-for-user-execute-permission-was-denied?forum=sharepointadmin

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    vendredi 6 juillet 2018 06:13
  • Hi Grace
    Thanks for your useful suggestion.
    As per my knowledge those permission will automatically granted for the service account during the configuration. So is there any reason or any scenario where we need to grant the permissions manually.
    vendredi 6 juillet 2018 10:31