Re: Reason: Not associated with a trusted SQL Server connection.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Beschler (JohnBeschler_at_discussions.microsoft.com)
Date: 01/15/05 

Date: Sat, 15 Jan 2005 06:11:01 -0800

Bob,

I don't think it's a problem with the IUSR account because ASP runs fine.
Unless you are telling me that the system tries to use the IUSR account when
accessing the DB. If that's the case, why? I am specifically telling the
OLEDB driver which user id and password to use to access the DB in the
connection string. If this is the case, can you tell me how to override this
behavior?

The full error message is: Login failed for user 'wink'. Reason: Not
associated with a trusted SQL Server connection. (Sorry I did not post the
full error message to begin with) so that seems to indicate that it is
attempting to connect to the DB with the correct user id.

I did read through the article you pointed me to, but cound not find
anything related to my specific issue.

Thanks,
John

"Bob Barrows [MVP]" wrote:

> John Beschler wrote:
> > I get the subject message when I try to Open the connectio the
> > database.
> >
> > Scenario:
> >
> > IIServer: Win XP
> > DB Server: Windows server 2003 running SQL Server 2000
> > Mixed mode is enabled on SQL.
> >
> > Machines are NOT in domain
> >
> > Connectio String = "Provider=SQLOLEDB;Data Source=192.168.0.4;User
> > ID=****;password=********;"
> >
> > Any IDeas?
> >
> > NOTE: Using a third party tool I am able to query the databse using
> > SQLOLEDB.1 driver
>
> In ASP, the IUSR account on your server is the user, not you. See the
> discussion of your error in this article (make sure you read the KB article
> it links to):
>
> http://www.aspfaq.com/show.asp?id=2009
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>

Relevant Pages

  • Mapped drives and FSO
    ... the machine running IIS that is running my ASP ... script uses the same IUSR account and password as the folder that I am ...
    (microsoft.public.inetserver.asp.general)
  • Re: Cannot Create New Instance of COM+ Object After You Repeatedly Restart the COM+ Object
    ... component but via asp it doesn't work. ... The server did not register with dcomm for the iusr account. ... and the iusr account was linked to active server 2.0. ... The component must be crashing somewhere - at least it's not being unloaded correctly; Your event viewer message will be for the problem caused, ...
    (microsoft.public.inetserver.asp.components)
  • Re: General ASP & COM Question.
    ... why doesn't this work in an ASP page? ... >> I suspected it had something to do with the IUSR account, ... >> IUSR to the AD Domain Administrators group and the same result, ... >> I've covered all the basis, I logged into AD with a normal user account ...
    (microsoft.public.inetserver.asp.general)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... UI work with ASP and SQL all day at work and do ... And we run our SQL server in mixed mode as well, ... I wrote a simple VB program that uses the same connection ... >> I don't think it's a problem with the IUSR account because ASP runs fine. ...
    (microsoft.public.inetserver.asp.db)
  • Re: [RE: [SQL connection string security]]
    ... Pooling would NOT be defeated because in this scenario all users run in the ... context of the IUSR account. ... If you use NTLM or basic auth then all bets are ... > trusted connection to a limited set of stored ...
    (Focus-Microsoft)