Kerberos / Authentication to SQL2K

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Paul Mason (masonp_at_cancer.bham.ac.uk)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 12:07:14 +0100

Hi folks,

I thought I'd got this sorted, but apparently not.

Everything in the documentation indicates that setting the IIS settings to
use integrated logins and changing my authentication mode in web.config to
windows would be all I needed to do. It didn't want to know the
authentication until I switched on impersonation either.

Thus my web.config has

<authentication mode="Windows"/>
<identity impersonate="true"/>

When ia had it setup on my local machine, it authenticated OK (which it
didn't before when in an NT domain).

When set up on my web server however, I get the "Login failed for user
'(null)'. Not associated with a trusted login" error, whenever I access a
page that needs to authenticate to my SQL server.

Each machine (web server, sql server, workstations) are in an active
directory domain.

I thought kerberos sorted this all out?? I have no intention of using
impersonation...I'd rather stick to forms authentication.

Any ideas??

Cheers...P

Relevant Pages

  • Re: WebBrowser
    ... With a Windows Authentication or Permission on a folder ... With this type of security you may be able to access the ... If the login page is a Username / Password textbox with a Submit or Login ... send requests to a web server and get some type of response / data back. ...
    (microsoft.public.vb.controls)
  • Re: Login Loop
    ... The security settings are Integrated Windows Authentication & Basic ... Re-appearing login prompts are never issues with the web server ... and I do not recommend wasting time with indirect methods. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Servlet authentication on Tomcat 5.5.7
    ... The Sun JDK provides a JAAS module for authentication against an NT machine ... With this JAAS login module ... against user database of the NT machine on which the web server runs. ...
    (comp.lang.java.programmer)
  • Re: Forms Authentication not functioning properly 100%
    ... > workstation (Windows 2000 Professional) in my office. ... when I move it to my Web Server which is running ... > Login page since I have not been authenticated. ... I have also tried a simple forms authentication ...
    (microsoft.public.dotnet.security)
  • Re: Seriously: Allowing anonymous and authenticated and anonymous access (somehow related to ASP.N
    ... with a mixture of IIS settings and extending the OnAuthenticate event in ... > It must be possible to use Windows Integrated Authentication in IIS to ... > enable Intranet users a seamless workflow (without having to login to ...
    (microsoft.public.dotnet.framework.aspnet.security)