Article ID: 115157, created on Nov 19, 2012, last review on Aug 12, 2014

  • Applies to:
  • Operations Automation 5.4

Symptoms

A customer has a SharePoint site in a language other than the base server language. This customer logs in to the site and clicks on the "Help" icon. The online help is not displayed. There is the following event on the Microsoft SharePoint Foundation 2010 Hosting Server:

Insufficient SQL database permissions for user 'Name: HOSTING\sh_p00000181 SID: S-1-5-21-555380253-3456105382-1177913091-13012 ImpersonationLevel: Impersonation' in database 'SharePoint_AdminContent_083f2bf5-02e6-431b-9d62-e1f9484ded18' on SQL Server instance 'sqlvs01'. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_EnumResourcesAtScope', database 'SharePoint_AdminContent_083f2bf5-02e6-431b-9d62-e1f9484ded18', schema 'dbo'.

Cause

The required permissions for the Web Application application pool account are not in place.

Resolution

  1. Make sure all help collections are completely installed. See the http://support.microsoft.com/kb/939313 KB article for details.

  2. Grant the required permissions to the Web Application application pool account:

    a. Log on to the Microsoft SharePoint Foundation 2010 Hosting Server as Domain Administrator.

    b. Open the Microsoft SQL Server Management Studio and connect to the SQL Server instance that is provided in the event.

    c. In the left area, go to Databases > <the SQL database that is provided in the event> > Security > Roles > Database Roles.

    d. In the left area, double-click the WSS_Content_Application_Pools database role.

    e. In the opened window, in the left area, select Securables.

    f. In the right area, make sure the proc_EnumResourcesAtScope and proc_EnumResourceValuesForAllLangs stored procedures are in the list and that they have the Execute permission. If you do not see these stored procedures, click Search to add the stored procedures to the list. Then add the Execute permission to the stored procedures. See the picture below for details.

    List of Permissions

    g. Validate that the online help is displayed on the site.

Search Words

Sharepoint menu

Attachments

2554725ed606193dd9bbce21365bed4e caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae ac82ce33439a9c1feec4ff4f2f638899 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF