Re: Permission required to execute a DTS package from ASP.NET applicatio?!!

Thanks Jeje,

> have you setup the impersonation in the web.config file?
Yes,I've enabled impersonation in my application and that's why it is under
the security context of my account "Domain\My UserName".

> does SQL server is on the same server as your ASP.net application?
No they are in different boxes!!! I think this is the problem

> do you use NTLM or Basic authentication?
I'm using NTLM (Windows integrated security).

Thanks again


"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
news:uWzExP2hFHA.1968@xxxxxxxxxxxxxxxxxxxxxxx
> does SQL server is on the same server as your ASP.net application?
> do you use NTLM or Basic authentication?
> have you setup the impersonation in the web.config file?
>
> "Ray5531" <Ray5531@xxxxxxxxxxxxx> wrote in message
> news:usCQ510hFHA.1372@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>
>


.

Relevant Pages

  • Re: DTS: exporting data to csv file
    ... XLS file (both XLS and CSV in the same security context)? ... I tried to save the package to a storage file, ... I thought in this way I can bypass some SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing a DTS Package from an application button
    ... call the package, since the package will then execute on their machine, ... under their security context. ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Security Running a DTS Package
    ... It depends on what you mean by run a package - through a job ... It sounds like you are referring to executing the ... security context of the SQL Agent service account. ... package but when it writes a file the SQL Server sceurity is no longer valid? ...
    (microsoft.public.sqlserver.dts)
  • Re: Msg Box and DTSRun
    ... runs on the machine which you execute it from. ... server you must executed it on the server, such as through a SQL Server ... It also runs under the security context of the user who calls ... the package, so from your desktop using Enterprise Manager or DTSRUN, ...
    (microsoft.public.sqlserver.dts)
  • Re: Yet another permissions thing
    ... following illustrates how to duplicate a token and use it to handle COM security context issues related to ... // Run this function on a separate thread using the impersonation token of the callers thread ... >>> the folder and Directory.CreateDirectory works fine. ...
    (microsoft.public.dotnet.framework.aspnet.security)