473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 2174
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...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.