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

Chris, I just, agonizingly, went through this same scenario. Here was my
problem.

In IIS, I opened the properties of my web application and I had to change
the default user (on the Directory Security Tab) that was entered there to
my domain account (or some other user's domain account that could log on to
the machine that SQL Server was residing on). Then I had to uncheck the Let
IIS manage the password checkbox and enter in my own password. I had to
leave Integrated Windows Authentication checked.
In my web.config, I had to have this tag:

<identity impersonate="true" />

When publishing, I believe I had to uncheck the Integrated Windows
Authentication to make it work on machines other than my dev box.

HTH
S

"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: FAILURE installing WSS with Active Directory auth
    ... SQL Server should also be running under a Domain Account. ... Did you add IIS after the server was promoted to a DC? ... > - local admin as well as admins in AD. ...
    (microsoft.public.sharepoint.windowsservices)
  • Is it possible for IIS and SQL server on Separate Machines with integrated auth
    ... Is it possible for IIS and SQL server on Separate Machines ... with integrated windows Authentication in ASP.NET? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • IIS & SQL Server
    ... having both IIS and SQL Server on different boxes? ... using the credentials supplied by the user, via their browser, to connect ...
    (microsoft.public.sqlserver.security)
  • set permission for a process id use in app
    ... how do i set permission in IIS for a Process ID/Generic ... domain account to be used in accessing SQL server ...
    (microsoft.public.inetserver.iis.security)
  • Re: set permission for a process id use in app
    ... Set the anonymous user account in IIS to be the domain account you want ... Allow that domain account to login to SQL Server ... how do i set permission in IIS for a Process ID/Generic ...
    (microsoft.public.inetserver.iis.security)
Loading