Cube process fails

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  May 23, 2006 at 1:29 pm

  #115218

  I get the following error when processing cubes

  Step 'DTSStep_DTSOlapProcess.Task_1' failed

  Step Error Source: DSO

  Step Error Description:Cannot connect to the repository.

  Analysis server: 006-PM2-SQL01

  Error:

  Unspecified error

  Step Error code: 80040033

  Step Error Help File:

  Step Error Help Context ID:1000440

  Step Execution Started: 5/23/2006 11:52:57 AM

  Step Execution Completed: 5/23/2006 11:52:57 AM

  Total Step Execution Time: 0.125 seconds

  Progress count in Step: 0

   

  what could be wrong?

• Yaniv Mor

  SSC Eights!

  Points: 936

  More actions

  May 24, 2006 at 5:32 pm

  #639929

  Hi Shahab,

   

  This is probably a security issue, meaning the user who is running the DTS does not have sufficient permissions to connect to the OLAP server.

   

  HTH,

  Yaniv