I have the following setup:

a) IIS, Sql Server 2000 all running on my laptop (WinXP). I am running
..net 1.1.

b) I have a DTS package. I can execute the DTS package directly from within
the Enterprise Manager. It works correctly.

c) I have an ASP.net application which attempts to load and execute the
package. I get the following error message:

"Exception Details: System.Runtime.InteropServices.COMException:
Invalid authorization specification"

and it appears to be objecting to my attempt to load the package. The line
that I am using for loading the package is as follows:

p.LoadFromSQLServer("localhost", "", "",
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null,
null,"Gard2SDFPackage", ref pVarPersistStgOfHost);

Where p is the package that I have defined.

I use windows authentication for my SQL Server.

Anyone see anything obviously wrong with what I am doing, or my setup?

Thanks,
William

All,

I found out the problem. In the statement where I was loading the package,
I needed to use the "Trusted connection" flag instead of the default one.

-- William

"William Pierce" <evalsinca (AT) hotmail (DOT) com> wrote