April 18, 2003 at 8:08 am
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
April 18, 2003 at 8:20 am
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
Michael Weiss
April 18, 2003 at 9:04 am
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
April 18, 2003 at 10:47 am
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
Michael Weiss
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply