Executing DTS from .net with users credentials

[Guest]

Hello,

We have a DTS package which we execute from an IIS application. The problem
is that the DTS fires off, but does not import anything in the SQL database,
unless we make the user a member of the local administrators group on the
webserver.

The package itself requests data from a local share of the server and users
have permission to access that share and the data.

The database permissions are correct since it works when the user is local
admin on the webserver only.

Does the execution of a DTS package through an IIS application require
permissions such as: Act as part of the OS, Logon Locally, Logon as Batch
Job???

Thanks in advance

 

[Frans Bouma [C# MVP]]

Hello,

We have a DTS package which we execute from an IIS application. The
problem is that the DTS fires off, but does not import anything in
the SQL database, unless we make the user a member of the local
administrators group on the webserver.

The package itself requests data from a local share of the server and
users have permission to access that share and the data.

The database permissions are correct since it works when the user is
local admin on the webserver only.

Does the execution of a DTS package through an IIS application
require permissions such as: Act as part of the OS, Logon Locally,
Logon as Batch Job???

you could save the DTS package in Sqlserver, and run it with a job, by
using sp_start_job system stored procedure. You can then start that
stored procedure by using an Sqlserver login, for example a user which
is part of the required groups inside sqlserver.

Another way is to use impersonation in your asp.net application, to
impersonate to a user which more credentials and then start the job.

Frans

--

 

[Guest]

Seems, the all problems rely on old service packs rule applies also here..

Service pack 3a on the application server for the SQL tools solved the
problem.

We think it has something to do with the TEMP folder storage. .

But it works..! Thanks for all answers