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

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 01/15/05 

Date: Sat, 15 Jan 2005 10:02:01 -0500

Are you sure SQL Server is set up to use both SQL Authentication and Windows
authentication? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"John Beschler" <JohnBeschler@discussions.microsoft.com> wrote in message
news:6973277B-E076-4386-B87D-0CE51569CE0A@microsoft.com...
> 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

  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... but does that mean ASP uses the IUSR account to access the SQL ... > There are two sets of authentications: Windows, and SQL Server. ... If using integrated security, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Datbase Results Error
    ... would take away the trusted connection option. ... Unless the IUSR account for that computer has been mapped to a valid ... > SQL Server account, SQL Server will reject it because it knows nothing about ... > Server of a valid SQL Server account and disable the Trusted connection ...
    (microsoft.public.frontpage.client)
  • DNS Server Error when Hitting Database?
    ... The application accesses a SQL Server database ... (separate machines for database and web server). ... IUSR account doesn't have access to our DNS server, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connect to Desktop SQL Server 2000 from Pocket PC
    ... SSPI is in fact supported, but you have to provide user ID and password ... This might be useful if SQL authentication is disabled on a server. ... > Xref: cpmsftngxa10.phx.gbl ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Windows Service Login Failed when accessing SQL.
    ... SQL Authentication should work since you specify the login ID and password ... connect to the SQL Server DB successfully. ... > Windows Service Login Failed when accessing SQL. ...
    (microsoft.public.dotnet.distributed_apps)