Login failed for user '(null)'. vs asp.net

R

rl30

ASP.NET vs SQL Server¸

I have an ASP.NET Application
In IIS I checked the Integrated Windows Authentication
option

In Web.Config the connection string include Integrated
Security = SSPI
and Impersonate=true in Web.Config

When I start then Web Application I have this messge
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
Could you help me

PS My account have the permission to connect to SQl Server

the security model is base on role security
I have many users
 
I

Ian

Hi,

This should fix it (ASP.NET won't impersonate if you have IIS allowing
anonymous access first) but if you still have the issue, turn on SQL
Profiler and trace the failed login.

HTH

Ian
 

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

Login failed for user '(null)'. Reason: Not associated vs asp.net 3
SQL Server connection string for deployment ? 1
ASP.Net/SQL Server Authentication 1
Login failed for user '(null)' 5
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. 10
newbie to asp.net... 1
Login failed for user (null). Not associated with a trusted SQLSe 6
Login failed for NT Authority\Anonymous Logon 2

Top