Re: Login failed for user '(null)'. Reason: Not associated with a



yes, i used impersonation <identity impersonate="true"/> in the web.config.
if i didn't, all accounts, userA and userB should failed to connect to
database.
however, acount, userA can access succesfully!

the database is installed on another machine from the web application.

"Scott Allen" wrote:

> Is the database on the same machine?
> Are you using impersonation <identity impersonate="true"/> ?
>
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
>
> On Fri, 29 Apr 2005 02:32:14 -0700, boy
> <boy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >I got the following error message when I access the web application, in which
> >the web application use SPPI to connect to database.
> >
> >"Login failed for user '(null)'. Reason: Not associated with a trusted
> >connection"
> >
> >The web application is grant to a group only in web.config
> > <authorization>
> > <allow roles="Domain\AGroup" />
> > <deny users="*" />
> > </authorization>
> >
> >I have two 2 accounts, userA and userB, which belong to the same group
> >"Domain\AGroup". userA can access the web application successfully, whereas
> >userB cannot and prompted the above error.
> >
> >Do all you have encountered the same problem?
> >
> >Thanks!
>
>
.



Relevant Pages

  • Re: MS Access - Only one person can open database at a time
    ... one person can get into the database at a time. ... Is the second user getting an error message? ... Is the scenario UserA can get into mdb and UserB can't? ...
    (comp.databases.ms-access)
  • Login failed for user (null). Reason: Not associated with a trus
    ... I got the following error message when I access the web application, ... the web application use SPPI to connect to database. ... I have two 2 accounts, userA and userB, which belong to the same group ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to hide unauthorized databases with SQL 2005?
    ... VIEW ANY DATABASE is granted to public by default. ... DENY VIEW ANY DATABASE TO userA ... grant that permission to users as you see fit. ...
    (microsoft.public.sqlserver.security)
  • Re: How to hide unauthorized databases with SQL 2005?
    ... Thanks for the reply Dan. ... I need to allow userA to see one database while denying other databases. ... grant that permission to users as you see fit. ...
    (microsoft.public.sqlserver.security)
  • Cross DB ownership chaining
    ... I am having trouble setting up cross db ownership chaining. ... Using SQL Server 2000 SP3a. ... Create new database A1. ... Grant select permission on vTableA to UserA. ...
    (microsoft.public.sqlserver.security)