locked
EXECUTE permission was denied on the object 'proc_EnumResourcesAtScope', database SharePoint_AdminContent RRS feed

  • Question

  • After applying SP1 with CU1 on SharePoint Foundation I keep getting the following error. The Application pool account in question is assigned to the WSS_CONTENT_APPLICATION_POOLS role associated with the SharePoint_Admin content database as outlined in Technet Article

    How do I correct this? Should the app pool account have db_owner permissions on the SharePoint_Admin database?

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Foundation
    Date:          2011.09.26 11:34:39
    Event ID:      5214
    Task Category: Database
    Level:         Critical
    Keywords:     
    User:          DOMAIN\IIS_pool_account
    Computer:      SERVER
    Description:
    Insufficient SQL database permissions for user 'Name: DOMAIN\IIS_pool_account SID: ID ImpersonationLevel: Impersonation' in database 'SharePoint_AdminContent' on SQL Server instance 'DB_SERVER'. Additional error information from SQL Server is included below.

    The EXECUTE permission was denied on the object 'proc_EnumResourcesAtScope', database 'SharePoint_AdminContent', schema 'dbo'.
    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
        <EventID>5214</EventID>
        <Version>14</Version>
        <Level>1</Level>
        <Task>3</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2011-09-26T08:34:39.534391900Z" />
        <EventRecordID>21861</EventRecordID>
        <Correlation ActivityID="{AB3CFA45-825C-4347-86CD-831383803C0E}" />
        <Execution ProcessID="8184" ThreadID="5780" />
        <Channel>Application</Channel>
        <Computer>SERVER</Computer>
        <Security UserID="ID" />
      </System>
      <EventData>
        <Data Name="string0">Name: DOMAIN\IIS_pool_account SID: ID ImpersonationLevel: Impersonation</Data>
        <Data Name="string1">SharePoint_AdminContent</Data>
        <Data Name="string2">DB_SERVER</Data>
        <Data Name="string3">The EXECUTE permission was denied on the object 'proc_EnumResourcesAtScope', database 'SharePoint_AdminContent', schema 'dbo'.</Data>
      </EventData>
    </Event><br/> 
    
    Tuesday, September 27, 2011 8:06 AM

Answers