On about 8 hours of this issue....and not getting very far, just short of
calling MS...:

DTS Works with the following:
IIS 5.0 > SQL 2kSp3 (on diff. boxes)
DTS is set in EM to run under SQL authentication.
Code on IIS box:
============
''STEP 3 execute package that inserts data from flat file to database
Set oPKG = server.CreateObject("DTS.Package")
oPKG.LoadFromSQLServer "EAGLE",,,256,,,,"ImportNextelData"
oPKG.Execute
oPKG.Uninitialize()
Set oPKG = Nothing
Response.Write("Package successfully executed <br>")

The above runs as IUSR_IISSever on the remote SQL Server..synchronized
IUSR_IISSERVER account and put as NT SQL User.

Again, above works just fine in IIS5, IIS 6 tangles this up!
When I apply the same with an IIS 6 server, I get authentication errors in
the NT event log for "IISServer$" (not IUSR but servername) failed. With
the new authentication defaults with IIS 6 the DTS Package does not run!
I've tried many compinations to get this to work w/o success. I understand
the programmer who chose this approach, with their code may have not been
the best decision, but I'm under the gun and need to make the existing work
with IIS 6.0.

TIA,
Dan Foxley

Hi Dan,

My name is Michael and I would like to thank you for using Microsoft
newsgroup.

Before we go any further, I would like to collect more information from
you:

1. What account you used to login SQL Server with IIS 6.0? Can you log on
SQL Server using this account?

2. If you run this problematic package using SQL Server Enterprise Manager,
does any problem occur?

3. Can you please configuring IIS for IIS 5.0 Isolation Mode to see if the
same problem occurs?

Also, such issues tend to be complex and take up extensive research time.
I'd like to set your expectations that it may take a while for us to help
you narrow down the problem and we may eventually redirect you to PSS to
continue working with a dedicated Support Professional. If this is
critical, I'd recommend contacting PSS and opening a Support incident
troubleshoot this further. If you need any help in this regard, please let
me know.

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

I've opened a case with MS PSS, I'll see what happens there and report back.

Dan

""Yuan Shao"" <v-yshao (AT) online (DOT) microsoft.com> wrote

Hi Dan,

Thanks for your feedback. It is appreciated that you can tell me the case
ID so that I can monitor this case more efficiently.

Thanks for choosing Microsoft.

Best regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

I believe this is the number, yes?
SRX040119609234

Dan Foxley

""Yuan Shao"" <v-yshao (AT) online (DOT) microsoft.com> wrote