Re: Datbase Results Error

From: Stacie Espinosa (StacieEspinosa_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 13:13:02 -0700

Thanks for helping, but I need a little help I can't seem to find where I
would take away the trusted connection option. Could you help me with this?
I don't know much about IIS i'm still trying to figure things out. Thanks A
LOT

Stacie

"Mark Fitzpatrick" wrote:

> Stacie,
> What is happening is you have the connection set to use a trusted
> user. What this means is it uses the information from the windows user that
> is accessing the server. In the case of a normal IIS user, that's the
> anonymous IUSR account. So, those credentials are being passed to SQL
> Server. 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
> the IUSR account. Instead, try passing the username and password to the SQL
> Server of a valid SQL Server account and disable the Trusted connection
> option. This way the credentials of the windows account won't be passed and
> it will instead use the username and password included in the connection
> string.
>
> Hope this helps,
> Mark Fitzpatrick
> Microsoft MVP - FrontPage
>
> "Stacie Espinosa" <StacieEspinosa@discussions.microsoft.com> wrote in
> message news:906BED81-B612-44CE-9E06-39D4A669EB63@microsoft.com...
> >I have posted quite o few question on one database results error using
> >access
> > as the database, but to know avail could not get it to work so now I am
> > trying SQL only I get this error now I figure its a permissions error but
> > I
> > tried resetting permissions but still get the same error is someone could
> > help that would be great
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> > 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > Thanks Stacie
>
>
>

Relevant Pages

  • Re: dsn-less connection
    ... Doug Steele, Microsoft Access MVP ... SQL Server login and was able to remove the specific dsn that's in the ... be possible to have it default to not Use Trusted Connection so it would ... Dim dbCurrent As Database ...
    (microsoft.public.access.security)
  • 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: One Connection String for Multiple Users (SQL)
    ... When you specify a trusted connection the user's credentials are used. ... I expect that the individuals with limited rights are not granted sufficient rights to the database or to the login account on the SQL Server. ... Our managers can access the data, but they are set up as Power Users. ... running Windows Vista. ...
    (microsoft.public.sqlserver.connect)
  • Re: dsn-less connection
    ... we always use Trusted Connection, so I don't have an opportunity to ... SQL Server login and was able to remove the specific dsn that's in the ... Dim dbCurrent As Database ...
    (microsoft.public.access.security)
  • RE: not associated with trusted connection
    ... Are you able to successfully connect using Integrated security via other applications from the same machine (e.g. UDL or Management Studio)? ... not associated with trusted connection ... I tried to connect to SQL Server 2005 using JDBC Driver 1.2 But I got the ...
    (microsoft.public.sqlserver.jdbcdriver)
Loading