locked
Login failed for user '(null)'. Reason: Not associated with a trusted SQL when i use IP address instead of localhost???? RRS feed

  • Question

  • I am getting Login failed for user '(null)'. Reason: Not associated with a trusted SQL when I use the IP address to access the dev version application from other machine.

     When I use the localhost through the application I am able to access the SQL Server without any error.

     Below is my configuration

     

     Trusted_Connection=true;integrated security=SSPI;

     <authentication mode="Windows"/>
      <authorization>
       <allow users = "*"/>
      </authorization>

     <identity impersonate="true"  />

     I am using Integrated Windows Authentication in IIS. I have access to windows user in SQL Server. I want to know why the connection string is using null even the user is authenticated in ASP.net

     Please provide me the cause of the issue and resolution.

     Thanks in Advance.

     


    .net world

     

    Monday, December 14, 2009 1:44 PM

All replies

  • In your IIS setting try to DENY anonymous access and then try to connect to your application.
    Thanks, Leks
    Monday, December 14, 2009 10:28 PM
  • Hello Leks,

    The Anonymous access in IIS is not enabled. I am using integrated windows authentication only.
    .net world
    Tuesday, December 15, 2009 5:14 AM