SQL Windows Authentication from ASP.NET

  • Thread starter Thread starter Greg Bacchus
  • Start date Start date
G

Greg Bacchus

Hi,
I need to log onto my SQL database using Windows Authentication from my
ASP.NET page. I have it working so that IIS requires Windows Authentication
and the Thread.CurrentPrincipal.Identity is comming through correctly, but
it doesn't seem to use that Identity in the SqlConnection (using integrated
security=sspi)... which seems odd to me.

Anyone have any ideas on how to do this?

Cheers,
Greg
 
Hi Greg,

Did you know that there is a special newsgroup

microsoft.public.dotnet.framework.security

I think that you find there easier a solution.

I hope this helps a little bit?

Cor
 
Hi Greg,

Did you configured web.config file properly?
<identity impersonate="true" />
 
Hi Greg
Even if you have activated impersonation in the webconfig (<identity
impersonate="true" />) you might have this problem. The reason is that
delegation isn't supported, meaning you won't be able to bring the
credentials of a user further from IIS to another physical server.

You find more details here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;810572

Hope this helps

Cheers Peter
 
Back
Top