Re: Windows authentication/impersonation.. login failed for user null?

You must make sure that domain user account or the domain security group
(that domain user account is in) ia mapped to a SQL server login/Sql Server
database user. That is, not all domain user account is automatically allowed
to access SQL Server, you need to explicitly create SQL Server login that
maps to a domain group/user, and then make specific SQL Server login as
given database's user/owner...


"Not Me" <Not.Me@xxxxxxxxxxxxxxx> wrote in message
news:1166543081.728376@xxxxxxxxxxxxxxxxxxxx
Hey,

We have an sql server 2000 machine and IIS 6 machine running seperately
but on the same domain. I can connect fine to the database without using
impersonation, but when it's enabled I get the error:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."

When I check System.Security.Principal.WindowsIdentity.GetCurrent().Name I
get the valid domain user that I would expect, why isn't this user being
checked against the sql server?

cheers for any help,
Chris



.

Relevant Pages

  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Linked Server Connection Error: 18459
    ... Did either of your SQL Server instances run under a domain user account? ... I recommend that you first ensure that your SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Disallow administrator access
    ... Remove the builtin\Administrators from the SQL Server instead of deny. ... "Todd Hazer" wrote in message ... > I have added my domain user account to the security logins and set ... > Jonas Larsen wrote: ...
    (microsoft.public.sqlserver.security)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... Server database user. ... not all domain user account is ... automatically allowed to access SQL Server, ... SQL Server login as given database's user/owner... ...
    (microsoft.public.dotnet.framework.aspnet)