DTS + ASP.NET

From: Chamindu R Munasinghe (chamindu_at_hsenid.lk)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 11:19:07 +0600

Hi
   I use a aspx page to call a DTS in my application. the application is
configured to use windows authentication and identity impersonation is
turned on. I load the DTS package using windows authentication. The web
application and the database server is on two different machines and the
domain controller ( W2K) is on the web server. when I access the application
from the web server itself it works fine but if I access it from another
machine it gives the error login failed for NT AUTHORITY\ANONYMOUS LOGIN
when I try to load the DTS package.

Thanks
Chamindu

Relevant Pages

  • Re: Using DTS to update a cental SQL server from MSDE
    ... You could certainly do this yes using DTS yes but it smacks more of being something for which I would use replication. ... machines use the same schema. ... I would like to setup a central SQL server to ... pull the machine names that I wish to copy the DBs from. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and ASP
    ... ...and no you don't need Excel installed on the web server, just DTS ... > I have seen many examples of ASP and DTS package, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DTS Package
    ... All I did on the development machine was add a reference to DTS, now SQL and VS.Net are both not installed on the web server itself, I upload the project and the SQL server resides on another server accessible to the web server. ... Fadi ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: server.createobject("DTS.Package")
    ... Since this object is created on the web server, and the execute command ... is issued on the web server, are you saying that the DTS runs on the web ... server even though the DTS package itself is on a different box? ...
    (microsoft.public.sqlserver.dts)
  • Re: Multiple Computers, First takes mail, second cant get it.
    ... copy of messages on the server. ... Do this on all machines, but be sure to set one machine to delete messages, ... MS-MVP. ... [DTS] ...
    (microsoft.public.windows.vista.mail)