SQL Server Performance Forum – Threads Archive

DTS scheduled job failure

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

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.

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.

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.

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

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…

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.

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

]]>