Re: impersonation
From: Noël Thoelen (noel_at_itomni.com)
Date: 10/29/04
- Previous message: Andy Fish: "creating a user profile for the aspnet user"
- In reply to: Noël Thoelen: "impersonation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 29 Oct 2004 10:42:50 +0200
I was looking around in some of the other posts in this newsgoup and
something came up to me.
I am using an lmhost file to reach the site. So, the site is not reached
using DNS. Could this be the problem ?
"Noël Thoelen" <noel@itomni.com> schreef in bericht
news:eDuamBZvEHA.1984@TK2MSFTNGP14.phx.gbl...
>I would like to use KERBEROS delegation to access an SQL Server database
>from an ASP.NET application.
> So, I have set up a website, disabled anonymous access and checked the
> windows integrated security.
> In the ASP.NET applicatie, the web config file contains
> <authentication mode="Windows" />
> <identity impersonate="true" />
> Both the IIS and the SQL server are part of a domain. So, when I browse to
> the site using an domain account
> the site will open fine. However, when i try to open a database connection
> using the 'Integrated security=SSPI option i always get the error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> When I open the database by using SQL authentication, everything works
> fine.
> On the IIS, the Webservice is running under local system account, and so
> is the SQL Server.
> In AD I have set the 'Trust computer for delegation' flag for both the IIS
> and the SQL as stated in the 'Troubleshoot KERBEROS delegation' document,
> but still without any luck
>
> Does somebody has encountered this problem already ?
>
- Previous message: Andy Fish: "creating a user profile for the aspnet user"
- In reply to: Noël Thoelen: "impersonation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
