Re: Cannot execute DTS package

From: Hermit Dave (hermitd.REMOVE_at_CAPS.AND.DOTS.hotmail.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 20:40:25 +0100

good old asp.net.
Whats happening is that it is trying to execute the Query with context of NT
AUTHORITY\NETWORK SERVICE
since you are using trusted connection.

so either set up the above user to access SQL & the database.
or just use impersonate identity tag to impersonate a fixed user.

matrix detailing the execution context with asp.net
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetAP05.asp

code project article which has snippet to allow aspnet account (worker
process in 2003 runs under Network Server) to the database
http://www.codeproject.com/cs/database/sql_in_csharp.asp 

-- 
Regards,
Hermit Dave
(http://hdave.blogspot.com)
"Peter Afonin" <peter@gudzon.net> wrote in message
news:uV0th3omEHA.592@TK2MSFTNGP11.phx.gbl...
> Hello,
>
> Our SQL server used to run under System account, and I had no problems
> executing DTS packages from the ASP.NET:
>
> Dim oPkg As DTS.Package
> oPkg = CreateObject("DTS.Package")
> oPkg.LoadFromSQLServer("WIN2000", , ,
> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , ,
> "Import DPCK")
> oPkg.Execute()
> oPkg.UnInitialize()
> oPkg = Nothing
>
> Then we switched to the different account, and I cannot execute packages
> anymore. I tried all accounts, including thos that have full access and
> rights. If I use
>
> DTSSQLStgFlag_UseTrustedConnection
>
> I get this error
>
> System.Runtime.InteropServices.COMException (0x80040E4D): Login failed for
> user 'NT AUTHORITY\NETWORK SERVICE'. at
> DTS._Package.LoadFromSQLServer(String ServerName, String ServerUserName,
> String ServerPassword, DTSSQLServerStorageFlags Flags, String
> PackagePassword, String PackageGuid, String PackageVersionGuid, String
> PackageName, Object& pVarPersistStgOfHost) at
> MakeXeroxFiles.MakeFiles.btnMake_Click(Object sender, EventArgs e)
>
> If I use the flag DTSSQLStgFlag_Default and specify user name and
password,
> I still get similar message:
>
> System.Runtime.InteropServices.COMException (0x80040E4D): Login failed for
> user 'SPECIALTY\pafo'. at DTS._Package.LoadFromSQLServer(String
ServerName,
> String ServerUserName, String ServerPassword, DTSSQLServerStorageFlags
> Flags, String PackagePassword, String PackageGuid, String
> PackageVersionGuid, String PackageName, Object& pVarPersistStgOfHost) at
> MakeXeroxFiles.MakeFiles.btnMake_Click(Object sender, EventArgs e)
>
> If I add <identity impersonate="true" /> to the Web.config, I don't get an
> error anymore, but the package doesn't execute either.
>
> What can I do? I would appreciate your help very much.
>
> Thank you,
>
>
> -- 
> Peter Afonin
>
>

Relevant Pages

  • Re: Cannot execute DTS package
    ... Whats happening is that it is trying to execute the Query with context of NT ... > executing DTS packages from the ASP.NET: ... > String ServerPassword, DTSSQLServerStorageFlags Flags, String ... > String ServerUserName, String ServerPassword, DTSSQLServerStorageFlags ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot execute DTS package
    ... > "Hermit Dave" wrote in message ... >> Whats happening is that it is trying to execute the Query with context ... >>> executing DTS packages from the ASP.NET: ... >>> String ServerPassword, DTSSQLServerStorageFlags Flags, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot execute DTS package
    ... > "Hermit Dave" wrote in message ... >> Whats happening is that it is trying to execute the Query with context ... >>> executing DTS packages from the ASP.NET: ... >>> String ServerPassword, DTSSQLServerStorageFlags Flags, String ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code wont execute Main Macro Calls - non breaking spaces
    ... replace string for the sake of clarification. ... My MAIN MACRO does not execute the first 2 options DO FIND AND ... Sub DoFindReplace(FindText As String, ReplaceText As String, _ ... .MatchWholeWord = False ...
    (microsoft.public.word.vba.general)