I want my MS Analysis Services 2000 OLAP cubes to be reprocessed once per
week after new data is loaded. I created a DTS package using an Analysis
Services Processing Task to process the whole database and scheduled it to
run at the appropriate time. However, when the job runs it fails with the
following error:

Executed as user: LEC_DOMAIN\SQLServerService. DTSRun: Loading...
Error: -2147024891 (80070005); Provider Error: 0 (0) Error string:
Access is denied. Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context:
713. Process Exit Code 1. The step failed.

LEC_DOMAIN\SQLServerService is the owner of the job and also the Windows
account that SQL Server and SQL Server Agent runs under. The MSOLAP service
runs under the system account. LEC_DOMAIN\SQLServerService belongs to the
OLAP Administrators role on the Analysis server, so it should have
permission to process the cubes. LEC_DOMAIN\SQLServerService also has Full
Control over the Microsoft Analysis Services folders on the hard drive.

Any ideas?

Can you execute the package manually ?
Can you execute it whilst logged into the server?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Laurence Neville" <laurenceneville (AT) hotmail (DOT) com> wrote

Yes, I can execute the package successfully through Enterprise Manager under
my login, either from the server or from a workstation..

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote