DTS PACKAGE PROCESSING DSO ERROR: 255

[DFW1999]

Hi,

I have developed DTS Package in a Clustered environment in SQL2000 Analysis server.I can execute this package from Enterprize Manager design window successfully.
Now I want to automate this process through scheduling a Job. I created a job for this package to execute. The user which is running this job has all Domain level Administrative permissions.

In my DTS package I am runing sripts to create dimension as well as fact tables. these scripts are running successfully as a part of this package.
Once I run this scheduled job I come across the following error while processing cubes:

"
Error:

Error source: DSO

Help file:

Help context: 1000440



DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_5

DTSRun OnStart: DTSStep_DTSCreateProcessTask_1

DTSRun OnStart: DTSStep_DTSActiveScriptTask_11

DTSRun OnFinish: DTSStep_DTSActiveScriptTask_11

DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1

DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1

DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2147221466 (80040026)

Error string: Your permissions on the server computer do not allow you to administer this Analysis server.
"
If I can get some clue of cube processing failure and recommended remedy I will appreciate it.
thanks

 

[DLSQL]

When you say that the user running the job has domain admin permissions, do you mean the owner of the job or the SQL Server Agent account?

Is the user a member of the SQL Svr Fixed role SysAdmins?

DL
MCDBA, MCSD, MCT, etc.

 

[DFW1999]

DLSQL,
Thanks for reply.

Answer to the first inquery is The User running the Job is 'X' and SQL SERVER Agent is 'Y'. Both 'X' and 'Y' are the members of Adminstrator group.

About second inquery, both 'X' and 'Y' are the member of SQL SVR Fixed role SysAdmins.

User 'X' is scheduling the job for DTS package through SQL SERVER AGENT Account ('Y') on Node1. The Analysis Server is running on Node2. Both Nodes are clustered.

Any Suggestions would be appreciated.
thanks

 

[DFW1999]

DLSQL and Others,

I still need some help regarding this issue.

thanks

 

[DFW1999]

Is somebody there to give some recommendations about this issue?

thanks

 

[DLSQL]

Are both X and Y administrators on node 2? Are they both Server Admins on node 2? Are they both members of the local NT group OLAP Administrators on node 2?

DL
MCDBA, MCSD, MCT, etc.

 

[DFW1999]

DLSQL,

the answer to your reply is as follows:

Are both X and Y administrators on node 2? YES

Are they both Server Admins on node 2? YES

Are they both members of the local NT group OLAP Administrators on node 2? YES

Thanks

 

[MDXer]

make sure that the account the job is running under is a Member of the OLAP Administrators group. Analysis Services maintains its own Admin group and if an account is not a member of that group then problems will arise.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck