SQL Windows Authentication from ASP.NET

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
 
C

Cor

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
 
M

Miha Markic [MVP C#]

Hi Greg,

Did you configured web.config file properly?
<identity impersonate="true" />
 
P

Peter Zuber

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
 

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

ASP.Net/SQL Server Authentication 1
Windows authentication from ASP.net application to Sql Server 7
Login failed for user '(null)'. vs asp.net 2
Windows Authentication 4
Connecting to SQL Server using Windows Authentication 4
ASP.NET 2.0 Windows Authentication 1
newbie to asp.net... 1
Public ASP.NET app and SQL Server security - best practices? 4

Top