Open the Microsoft SQL Server Management Studio. Navigate to the Database roles for the SharePoint AdminContent database: (local)\SharePointinstance –> Databases –> SharePoint_AdminContent_8a628b24 –> Security –> Roles –> Database Roles
Double click WSS_Content_Application_Pools. This will open the Database Role properties. On the left hand side, select Securables. Look for the following entries:
- proc_EnumResourcesAtScope
- proc_EnumResourceValuesForAllLangs
Click Search… –> Specific objects… –> OK –> Object Types –> select Stored procedures –> OK –> enter the above 2 entries: proc_EnumResourcesAtScope and proc_EnumResourceValuesForAllLangs –> Click Check Names and accept –> OK.
Now the stored procedures are added to the WSS_Content_Application_Pools Database role. Now we need to add the Execute permission for this database role.
To do this, select the 2 entries, and check Execute. After you are done, click OK.