By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Cannot execute DTS package

P: n/a
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_UseTrus tedConnection, , , ,
"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
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/de...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/databa..._in_csharp.asp

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Peter Afonin" <pe***@gudzon.net> wrote in message
news:uV*************@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_UseTrus tedConnection, , , ,
"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

Nov 18 '05 #2

P: n/a
Thank you very much, Hermit, it worked.

The problem was that when I tried to add 'NT AUTHORITY\NETWORK SERVICE'
manually in Enterprise Mgr - I couldn't find it (I don't understand why),
but when I ran
EXEC sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' - it worked.

Peter

"Hermit Dave" <he************@CAPS.AND.DOTS.hotmail.com> wrote in message
news:uD**************@TK2MSFTNGP12.phx.gbl...
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/de...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/databa..._in_csharp.asp

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Peter Afonin" <pe***@gudzon.net> wrote in message
news:uV*************@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_UseTrus tedConnection, , , ,
"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


Nov 18 '05 #3

P: n/a
yeah i tried it through enterprise manager as well and finally i went the
query analyser way to execute the stored procs :)

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Peter Afonin" <pe***@gudzon.net> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...
Thank you very much, Hermit, it worked.

The problem was that when I tried to add 'NT AUTHORITY\NETWORK SERVICE'
manually in Enterprise Mgr - I couldn't find it (I don't understand why),
but when I ran
EXEC sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' - it worked.

Peter

"Hermit Dave" <he************@CAPS.AND.DOTS.hotmail.com> wrote in message
news:uD**************@TK2MSFTNGP12.phx.gbl...
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/de...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/databa..._in_csharp.asp

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Peter Afonin" <pe***@gudzon.net> wrote in message
news:uV*************@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_UseTrus tedConnection, , , ,
"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



Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.