Analysis Services Processing Task Fails When Run By SQL Server Agent

Question

I have an SSIS package which contains an Analysis Services Processing Task. This package is kicked off by a SQL Server Job in SQL Server 2008 R2.

If I run this job myself or process the cube manually everything is fine.

However if I schedule the job and let the SQL server agent run it then the Analysis Services Processing task fails stating Errors in the OLAP storage engine and that an error occurred while processing the one of the measure groups.

Has anyone else every seen anything like this?

Answer 1

The SQL Server Agent service account may not have sufficient permissions. You can validate this by doing any of the following:

1. Add the service account to the Administrators group on the analysis services server to validate this issue. Let the job run as scheduled.
2. Create a proxy that runs under your credentials and set the job to execute under the proxy. Let the job run as scheduled.
3. Change the SQL Server Agent to use your credentials. Let the job run as scheduled.

If the job completes successfully after making any of the above changes, then you have a permission issue that you need to resolve.