Re: IIS not passing logon info consistently

From: Tom Kaminski [MVP] ((A@T))
Date: 04/01/03 

From: "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org>
Date: Tue, 1 Apr 2003 15:07:23 -0500

"Kevin Jones" <kjones@mtpi.com> wrote in message
news:#yifmUI#CHA.2820@TK2MSFTNGP11.phx.gbl...
> We have two W2K servers setup, one running IIS5 and the other SQL2K
>
> An asp application is configured to use integrated security
> (SQLCON.Properties("Integrated Security").Value = "SSPI") and for the most
> part, clients accessing the site are automatically logged into sql using
> their NT username/password. For the most part.
>
> At least a couple of times a day a client that could previously access the
> site is greeted with an error page (Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.)
>
> I have checked the advanced settings in IE, enabling "Enable Integrated
> Windows Authentication".
>
> It appears that IIS is not passing the credentials it receives from the
> browser onto SQL server, though I cannot determine why.
>
> Any help would be appreciated. I'm at the point of giving up and setting
up
> SQL Users for the database in question.

You will have problems using Integrated Security with SQL on a different
box.
http://support.microsoft.com/?id=176377
http://support.microsoft.com/?id=247931
http://support.microsoft.com/?id=176380
http://support.microsoft.com/?kbid=319723 

-- 
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

Relevant Pages

  • using Integrated Security SSPI with User ID
    ... I'm trying to use integrated security with a User Id and password to ... The SQL Server administrators insist that I ... use the intergrated security option in the connection string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Using Integrated Security for Accessing SQL on Remote Server
    ... I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet). ... I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Login failed for user (null). Reason: Not associated with a trusted SQL Server connection from A
    ... Originally the app was set up to use sql security and not windows ... the IUSR account be able to access the SQL server if that user was created ... > sql server using integrated security. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS not passing logon info consistently
    ... clients accessing the site are automatically logged into sql using ... >> browser onto SQL server, ... > You will have problems using Integrated Security with SQL on a different ... > Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis.security)
  • IIS not passing logon info consistently
    ... An asp application is configured to use integrated security ... clients accessing the site are automatically logged into sql using ... I have checked the advanced settings in IE, ... browser onto SQL server, ...
    (microsoft.public.inetserver.iis.security)