Kerberos and ASP NET application



Hi All

First time poster to this group,and this is my first experience
looking into the intricacies of Kerberos.

Anyway, I've developed a vanilla asp .net application. It has a web
tier which connects to a web service which talks with the SQL server -
a very standard set-up. I have set the web application to use
integrated authentication and hence Kerberos, as retrieving the
information requires two hops.

I have set up IIS and the web config files as recommended by microsoft
(and confirmed across the web). I have set the service principals and
set the delegations correctly. And I was very pleased with myself
when the application worked as expected from my machine. I was also
very happy when it worked from my bosses machine. I wasn't so happy
when it didn't work from my customer's machine (all on the same
network).

That's when my adventure in Kerberos, and pain, began. In a nutshell,
some machines authenticate using Kerberos, while others default to
NTLM and the SQL server won't (rightly) let them in (ERROR message
is : Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.). We even had the great test case of a
user with 2 similarly configured machines being able to connect
successfully with one but not the other!! Sigh.

As further background:

client is IE7 on Win XP SP2 - and enable integrated authentication
is selected;
web server is on a virtual server running windows 2003
app server is also on this server (for now)
sql server is SQL 2000 on a Win 2003 box.

Now I've tried everything I can glean from the web to see what the
differences between the 2 machines are - and I have come up with
nothing. ZIP. Everything seems to be in order, but obviously
something isn't!! I have run some limited packet sniffing, but that
isn't really my forte - using Netmon, I could see that there was a
Kerberos error (the error code was 0x3e - KDC_ERR_CLIENT_NOT_TRUSTED ,
but that didn't really give me much to go on). I have compared
workstations and accounts in active directory, with no success. I
have compared IE7 properties - nothing.

Has anyone ever had this sort of problem before - ie Kerberos seems to
work for some workstations but not others? Or can anyone suggest some
diagnostics or something that I can run that might lead me down the
right track?

I'm nearing breaking point on this one - am even taking the day off
tomorrow to go fishing to see if something comes up ;-)

Cheers and grateful for ANY help or advice.

James
.



Relevant Pages

  • RE: Kerberos and ASP NET application
    ... I had this problem and after a lot of support call time with Microsoft, ... looking into the intricacies of Kerberos. ... NTLM and the SQL server won't let them in (ERROR message ... client is IE7 on Win XP SP2 - and enable integrated authentication ...
    (microsoft.public.inetserver.iis.security)
  • Re: View Type of Protocol
    ... Thanks a lot for the feedback John. ... information about the type of authentication being used. ... some reason Kerberos is not available. ... they are not authenticated and the SQL Server login fails. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: sql2005/linked server+imperonate
    ... When you go from the first SQL Server to the second SQL ... Active Directory attempts to use Kerberos as the authentication method first. ... so through delegation, but you have to do some setup. ...
    (microsoft.public.de.sqlserver)
  • Re: Cannot generate SSPI context and Windows 2000 service pack 4
    ... This happens because of a Kerberos authentication protocol issue, ... Enable Kerberos logging on the client machine (documented at ... connect to the remote SQL Server, if you get the same error message then ... having some error messages on the APPLICATION eventlog of the SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Kerberos w/ SQL and WIN2000
    ... Could you tell me what you changed in the SPN registration? ... > I found the following KB useful in troubleshooting Kerberos issues ... > the SPN for the SQL Server which made me go back and edit the ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)