all groups > sql server dts > august 2003 >
You're in the

sql server dts

group:

DTS Execution Context



DTS Execution Context David Robbins
8/13/2003 6:35:47 AM
sql server dts: Hello all,

How can I determine what context a DTS package runs under
when executed from a dll? I am attempting to execute a
DTS package from a asp script. The COM+ component has
the proper privileges, but the job is failing when
executed from the web. When I run the job manually in
DTS, the job complete successfully.

The error I receive is:

DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart: DTSStep_DTSDataPumpTask_6

DTSRun OnError: DTSStep_DTSDataPumpTask_6, Error = -
2147467259 (80004005)

Error string: [Timberline][Timberline ODBC Driver]
[File Library]Timberline ODBC Driver not activated.

Error source: Microsoft OLE DB Provider for ODBC
Drivers

Help file:

RE: DTS Execution Context v-rxwang NO[at]SPAM online.microsoft.com
8/15/2003 4:30:05 PM
Hi David,

I have found some articles related to this issue, it seems to be IIS and
ASP security issue.

In the following article. If Allow Anonymous is checked, IIS will always
attempt to access the requested resource by impersonating the Anonymous
Logon account (by default, IUSR_machinename).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnauth/html
/dnauth_security.asp

306518 INFO: Troubleshooting Guide for 80004005 Errors in Active Server
Pages
http://support.microsoft.com/?id=306518

175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
http://support.microsoft.com/?id=175671

290398 PRB: Access Denied When You Try to Start DCOM Server
http://support.microsoft.com/?id=290398

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "David Robbins" <drobbins@taubman.com>
| Sender: "David Robbins" <drobbins@taubman.com>
| Subject: DTS Execution Context
| Date: Wed, 13 Aug 2003 06:35:47 -0700
| Lines: 29
| Message-ID: <101001c3619f$cd8e3850$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNhn82O3PR3QSEvQpSXriLGHh3Y3w==
| Newsgroups: microsoft.public.sqlserver.dts
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:37279
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Hello all,
|
| How can I determine what context a DTS package runs under
| when executed from a dll? I am attempting to execute a
| DTS package from a asp script. The COM+ component has
| the proper privileges, but the job is failing when
| executed from the web. When I run the job manually in
| DTS, the job complete successfully.
|
| The error I receive is:
|
| DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
|
| DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
|
| DTSRun OnStart: DTSStep_DTSDataPumpTask_6
|
| DTSRun OnError: DTSStep_DTSDataPumpTask_6, Error = -
| 2147467259 (80004005)
|
| Error string: [Timberline][Timberline ODBC Driver]
| [File Library]Timberline ODBC Driver not activated.
|
| Error source: Microsoft OLE DB Provider for ODBC
| Drivers
|
| Help file:
|
| Help context: 0
|
AddThis Social Bookmark Button