Post reply

Process Cubes remotely without linking servers?

  • July 19, 2010 at 11:36 am

    #139796

    Is there a way to set up a job to process the AS cubes located on a different server, without having to link the servers?

    We have a script that must run on the regular database immediately before the cubes are processed. We tried setting up a SQL Agent job to run the script, and then process the cubes that are stored on a different server. This part fails since it cannot connect to the other server (on the same domain - just not linked.)

    Thanks for any feedback.

    SQL Server 2005 SP3 Standard Edition

  • July 30, 2010 at 6:06 am

    #1200237

    Servers should not need to be linked for this to be accomplished.

    The account that SQL Agent runs under needs the relevant access to the relevant databases for processing purposes. Either that OR you run the SQL Agent SSIS job using a proxy account that has the required processing access aginst the relevant data sources

    Kind Regards, Will

  • July 30, 2010 at 8:29 am

    #1200369

    Will,

    Thanks so much for your help. We've got our job working now. You've solved a problem we've been struggling with for a while...

    Thanks again!

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

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