Post reply

DTS don''t run like scheduled job

  • January 4, 2006 at 6:57 am

    #166394

    I've a sql server agent proxy account named "sqloper" with user privilege.

    I login into my windows server (not client or workstation) with "sqloper"  account,the same login of proxy account, if I run a DTS with dtsrun.exe command in a DOS session the DTS works fine, but if I create a scheduled job (EM) with an application login (not SEVER ROLE applied) to execute the same DTS  the job abort.

    The DTS execute a "Analysis Services process task" and the error log is "Executed as user:deepcdbn1coll\sqloper. ...  DTSStep_DTSOlapProcess.Task_1   DTSRun OnError: 

    DTSStep_DTSOlapProcess.Task_1, Error = -2147221453 (80040033)      Error

    string:  Cannot connect to the repository.      Analysis server: DEEPCASCOLL 

        Error:   Cannot open database ''.  It may not be a database that your

    application recognizes, or the file may be corrupt.      Error source:  DSO  

       Help file:        Help context:  1000440    "

    Why I read :Cannot open database ''  , Where is "database name"? what happen? Why in a DOS session the DTS works fine and with a scheduled job the DTS abort ?

  • January 6, 2006 at 2:21 am

    #613126

    Could it be that the user deepcdbn1coll\sqloper does not have sufficient access for Analysis Services?


    Thanks Jeet

  • January 9, 2006 at 12:37 am

    #613462

    According to you which accesses to Analysis Services would have need the user "sqloper"?

    Can you help me?

    Thanks

  • January 9, 2006 at 5:14 am

    #613502

    UPDATE: I've tried to modify user "sqloper" from user to Administrator and DTS works fine.

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

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