SQL Server Performance

DTS scheduled job failure

Discussion in 'SQL Server DTS-Related Questions' started by matey, Jan 3, 2006.

  1. matey New Member

    Hi guys,

    I got the following error below after changing sql server service account on a sql server running analysis services.

    Executed as user: DOMAINSQLServiceAccount. ...un OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= DSO Error Description: Cannot connect to the Analysis server on computer 'SQL 2000'. Connection to the server is lost Error on Line 17 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= DSO Error Description: Cannot connect to the Analysis server on computer 'SQL 2000'. Connection to the server is lost Error on Line 17 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution comp. The step failed.

    Any response regarding the above error much appreciated...

    Cheers
    A
  2. Luis Martin Moderator

    If you have changed account, you have to recreate the job with new account.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. SQLGeek New Member

    A,

    This can be an involved topic generating a lot of questions. SQL BOL has a good article that covers DTS connection security...I believe it is called Package Security in DTS, or something close...and it covers SQL connection security, persistance settings, etc.
  4. satya Moderator

    Check privileges for that SQL service account on the dts package and its path if it processess network related information. Also check that DTS Package log for more information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. matey New Member

    Hi Luis,
    Yes the account that runs SQL Server has been changed and the job owner has also been changed to sa but the package owner is an account from another domain (trusted).

    A
  6. matey New Member

    Also could it be that analysis server does not recognise the SQL Service account because eventlog reports states that SQL Service account is trying to perform administrative tasks and it does not have administrative privileges, I am thinking SQL and analysis servers needs a restart...
  7. Luis Martin Moderator

    Try that and came backup to follow up.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  8. matey New Member

    The problem arose because sql service account was changed but not restarted and the problem disappeared after a restart of the services. Thanks guys

Share This Page