DTS Package Automate Cube update -
01-10-2005
, 02:11 PM
This is cluster box, active passive cluster. But the Analysis Service on
the server is not clustered.
The SQL Server is on the same box as the analysis service. The two cluster
server name is DWDBA & DWDBB. The database instance name is DWDB.
The analysis service is installed at the B node.
I created a DTS successfully to automatically reprocess the cube. It works
fine from the DTS Package. But it does not work from the scheduled job. The
user "OfficeDomain\MiMi" belongs a member of the OLAP Administrators group
on this server. I got the following error:
"The Job failed. The The Job was invoked by OfficeDomain\MiMi. The last
step to run was step 1 (1)."
"Executed as user: OfficeDomain\svc-nqagt. ...nStart:
DTSStep_DTSOlapProcess.Task_1 DTSRun OnError:
DTSStep_DTSOlapProcess.Task_1, Error = -2147221455 (80040031) "
"Error string: Unable to connect to the registry on the server (DWDBB), or
you are not a member of the OLAP Administrators group on this server."
Any clue about what is going on ?
Appreciate the help. Thanks. |