Kerberos / Authentication to SQL2K

P

Paul Mason

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
 
P

Paul Mason

Please ignore my previous post....I have finally discovered the madness of
the situation. From the help in visual studio :

"If your application runs on a Windows-based intranet, you might be able to
use Windows integrated security for database access. Integrated security
requires:
a.. That SQL Server be running on the same computer as IIS. "
Err what!?!....Are they mad? This breaks all the rules of good development,
appart from being about a dangerous as you can get. The mere suggestion of
this is so stupid that I completely overlooked it. Even when I spotted it I
had to read it several times to get over the shock.

Does anyone know when they are going to create a proper system for
authenticating users to SQL server? Is it likelly to happen in Whidbey?

Cheers...P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Kerberos Authentication 2
Kerberos 1
Impersonation / Kerberos 1
Kerberos Delegation Question 0
Windows Authentication 4
Kerberos delegation trauma 3
How to enable Windows Authentication 4
authentication problem 2

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top