472,954 Members | 1,659 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,954 software developers and data experts.

Is there a way to allow aspnet_wp.exe to execute a DTS Package that can be executed from a Windows Form application?

I have a Windows library that I bind into a Windows Form application and
into an ASP.NET Web Application. I have a procedure in the library that
executes a DTS Package. I have also used information from Knowledge Base
article 306158, INFO: Implementing Impersonation in an ASP.NET Application
to create a procedure to perform impersonation.

When I try to execute the DTS Package from ASP.NET, I get the following
error:

Step 'DTSStep_DTSTransferObjectsTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Access is denied.
(Microsoft Data Transformation Services (DTS) Package (80070005): Access is
denied.)
(Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on
'IFSERVER.RCIA.LOG'. Access is denied.)
Step Error code: 80070005

But when I call the same steps from a Windows Form application, the DTS
Package executes and there is no error.

I run IIS on an Active Directory Domain Controller, so I have setup a Domain
account called ASPUSER and set this account up as recommended in Knowledge
Base article 315158, FIX: ASP.NET Does Not Work with the Default ASPNET
Account on a Domain Controller.

When I have run the Windows Form application to successfully execute the DTS
Package, I have been logged on using my Domain Administrator account and I
have impersonated the ASPUSER Domain account. Both of these approaches
worked with no errors and the DTS Package executed successfully.

I have run the ASP.NET application using the ASPUSER Domain account and I
have impersonated the Domain Administrator account and both of these
approached have resulted in the error shown above.

The ASP.NET error is encountered whether I turn logging on or off in the DTS
Package.

This behavior leads me to think the aspnet_wp.exe program is being treated
differently than my Windows Form application, but I cannot find a way to
change the settings in a way that let's me successfully execute the DTS
Package.

If anyone has suggestions about what I can do to resolve this problem, I
would greatly appreciate the help.

Dean
Nov 17 '05 #1
1 2155
Hi,

You are in the right direction. ASP.NET default user has limited rights
and he canít activate other processes. You need to change the asp.net
user to one with right permissions. Just to prove my point use the
identity tag with user name and password of administrator JUST TO CHECK
AND THEN TO REMOVE!!! . I successfully run DTS this way, but Iím in
internal close intranet environment where the users arenít threat to the
system.

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chris | last post by:
I have yet to understand or get a response on the issue I'm having. I'm taking an asp web application and migrating it from Windows 2K to 2003. I have the new website location (2003) settings...
1
by: Angel Faus | last post by:
Hi, Our ASP.net application has stopped working. We are getting a "Server Application Unavailable" error, the message in the Event Log says it's due to wrong permissions on the .NET Framework...
4
by: Chris | last post by:
I posted this in the C# language group, then thought it might be more appropriate in this group. I would not cross-post except I want the answer so badly. I built small C# Web and Web Service...
4
by: Lynn | last post by:
hi, anyone knows how to fix this error? Event Type: Error Event Source: ASP.NET 1.0.3705.288 Event Category: None Event ID: 1082 Date: 1/18/2004 Time: 12:50:47 AM User: N/A
3
by: Ingo Lundberg | last post by:
So, I have a brand new PC with XP Professional SP2 and .Net 1.1 SP1 (no .Net 1.0). I also have VS.Net 2003. I create a new directory with Explorer and web share it. I create a new ASP.Net web...
0
by: Rocio | last post by:
Here I go again. Some time ago I wrote a VB.NET web service application that called a COM object written in VB6 using late binding. It was the only way I could call this object (see my posting in...
1
by: rAinDeEr | last post by:
Hi, I have started using DB2 UDB ESE v8.2 in Linux recently. I have seen a lot of articles on packages, prepare statement, bind and execute statement. I havent got a clear idea. I have...
4
by: =?Utf-8?B?TEJU?= | last post by:
Good day, I would like to execute an external application from a web form created using ASP.Net. I'm using System.Diagnostics.Process. It works fine if it is notepad.exe but it is not able to...
0
by: Jack Lee | last post by:
I try to set a job to run a DTS package, failed. My environment is SQL Server 2000 sp4 on windows Server 2003. There is a local window group called Dev_accnt including member SQLTesting who is...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
1
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.