Can't run DTS from ASP Page

Question

Can't run DTS from ASP Page

chriscahill

Valued Member

Points: 73
More actions
April 18, 2003 at 8:08 am

#105737

I have a package that runs fine from within enterprise manager, but if I try to launch it from an ASP page this error appears in the package error log:
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
Here is the conn string and ASP code (all of the XXX values are correct in the code):
"PROVIDER=SQLOLEDB;DATA SOURCE=XXXXXX;UID=XXXXXX;PWD=XXXXXX;DATABASE=XXXXXX;trustedconnection=yes"
set objPkg = server.CreateObject("DTS.package")
objPkg.LoadFromSQLServer "XXXXXX", "XXXXXX", "XXXXXX", 0,"","","","AlohaLaborExport"
objPkg.Execute
Running mixed mode authentication -- all web requests are made using SQL auth. SQL web user has permissions on all sprocs and tables necessary for this process.
Any thoughts on this?
Thanks,
Chris Cahill
Noodles & Co.
Edited by - chriscahill on 04/18/2003 08:10:17 AM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 1

What do you mean by SQL web user? The user logs on to your web site with their sql server or nt user credentials? Is anonymous access disabled in IIS? If not, then the package will be executed using the anonymous user account in IIS I believe. If so, you need to add this user (I_USR_ServerName usually) to SQL Server as a trusted account. Anyway, just my best guess...

hth,

Michael

Michael Weiss

chriscahill Valued Member Points: 73 More actions · Answer 2

The ASP page does login using SQL credentials. Anonymous access is disabled.

Is there any way to get around turning on anonymoud access and adding the anonymous account to the db?

Thanks.

Chris

quote:
What do you mean by SQL web user? The user logs on to your web site with their sql server or nt user credentials? Is anonymous access disabled in IIS? If not, then the package will be executed using the anonymous user account in IIS I believe. If so, you need to add this user (I_USR_ServerName usually) to SQL Server as a trusted account. Anyway, just my best guess...
hth,
Michael
Michael Weiss

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 3

Have you been to sqldts.com? Check out this article - maybe it will help.

http://www.sqldts.com/default.aspx?6,222,267,0,1

- or -

http://www.sqldts.com/default.aspx?6,104,207,7,1

hth,

Michael

Michael Weiss