Windows authentication with ASP.NET - big problem??!!

GornHorse

Well-known member
Joined
May 27, 2003
Messages
105
Location
Australia
Hi There,

This is what ive got...

> IIS has been configured to only accept Windows Authentication (deny anonymous users).
> Web.Config has <authentication mode="Windows"/>
> My current connection string is...
= "data source=SQLSERVER_001;initial catalog=REMS;integrated security=SSPI;"

When i debug, i get the following values...
context.user.identity.name = NT_DOMAIN\ADMINISTRATOR
system.security.principal.windowsidentity.getcurrent.name = MADPROGRAMMER\ASPNET
context.user.identity.authenticationtype = NTLM
context.user.identity.authentication = True

But, when it comes to connect to the database, it comes up with the error "Login failed for user (null). Reason: Not associated with a trusted SQL Server connection."

Why would it be trying to connect with a null? Does anyone have any advise on how i can fix this???


Regards,
Michelle
 
Back
Top