Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unnecessary system resources in SHAREPOINT server

Error :

Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume unnecessary system resources.

To configure the account use the following command 'stsadm -o setproperty -propertyname portalsuperuseraccount -propertyvalue account -url webappurl'. The account should be any account that has Full Control access to the SharePoint databases but is not an application pool account.

 Additional Data:

 Current default super user account: [MachineName]\system SharePoint 2010 is hosted on this machine.

Scenario :

The IIS APPPool account does not have access permission for the DB/tables and display the result.(in my scenario, SQL Server (SSRS) Reports not accessible).

Solution :

I gave DB_Owner permission for the user APPPool account to the DB.