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'.
The required permissions for the Web Application application pool account are not in place.
Make sure all help collections are completely installed. See the http://support.microsoft.com/kb/939313 KB article for details.
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.
g. Validate that the online help is displayed on the site.