process cube thorugh job service account issue

  • sorry if you've already thought of this but i thought i'd ask the obvious first:

    Has the service account got the rights to process the cube?

    Try connecting directly to the SSAS instance using the service account via management studio and manually processing the cube under that user.

    other than that i cant see why it wouldn't process your cube.

  • Service account has full privileges and i can process my cube through management studio by using the same account.

    I am getting the error when i execute the job (try with both xmla and SSIS) to process the cube.

    Also use through proxy but no luck.

    Can you suggest any other automated way by which i can process cube?

  • Thought it would of been too obvious (always worth asking the simple questions first though) and sounds like you've tried all variations too.

    There always powershell 🙂

    here's a link which could help with that:

    http://www.mssqltips.com/sqlservertip/2937/using-powershell-for-sql-server-analysis-services-tasks--part-1/

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply