Permission required to execute a DTS package from ASP.NET app

[Ray5531]

Hello,

I'm calling a DTS package from my asp.net application.Apparently because of
permission issue I canot run the package within the sql server ,because when
I set it to call a package from my local host it can execute te package.one
step before calling the package I get the IDENTITY of the current security
context and it is my Domian user name and I'm using IntegratedSecurity to
call the DTS package.I'm also memeber of sysadmin rols in Database.Do I have
to give it extra permissions?

Thasnk

 

[Pablo Galiano]

Hello,

I'm calling a DTS package from my asp.net application.Apparently
because of permission issue I canot run the package within the sql
server ,because when I set it to call a package from my local host it
can execute te package.one step before calling the package I get the
IDENTITY of the current security context and it is my Domian user name
and I'm using IntegratedSecurity to call the DTS package.I'm also
memeber of sysadmin rols in Database.Do I have to give it extra
permissions?

Thasnk

Hi Ray,

If you are using SSPI in the connectionstring, you have to impersonate the
call to the DTS.
You can do that by adding the next line to the web.config:
<identity impersonate="true" />

link: http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vsent7/html/vxconImpersonation.asp


Pablo

 

[J-T]

If you are using SSPI in the connectionstring, you have to impersonate the

call to the DTS.
You can do that by adding the next line to the web.config:
<identity impersonate="true" />

I've done this ,that's why the curent security context is under my
identity

Thanks