Login failed for user (null). Reason: Not associated with a trusted SQL Server connection

  • Hi

    My problem:

    I use MS .Net web application, which uses  MS SQL.

    Wen i run this app on a local computer (localhost, IIS, delegate set on this machine), app works fine, but

    wen i run this app on a serwer (IIS, also witch delegate set on) I get err message (topic).

     

    My web.config file:

    <authentication mode = "Windows" />

    <identity impersonate="true" />

    <authorization >

       <deny users="?" />

    <authorization />

     

    I also set tag <processModel> atrrib: 'username' to "system" (def: "machine")

    in my machine.config file in MS .Net framework config dir.

     

    Please help.

  • This was removed by the editor as SPAM

  • I had some similar problem with my web application likewise. The solution is that you will need to uncheck the anonymous Authentication of your virtual server for your application. This should work.

    Xesojay- - http://www.softedgesinc.com

  • I haven't mension, but I've did it before, and still don't works.

    I've also discover, that on some other test server my app. work fine (same configuration as the 'problem' server) 😐

    thanks, and regards.

    Martin.

  • My understanding of the problem is that when you access the web site on your localhost the application runs fine, however when you run the application on a separate web server you receive the error message.

    I am assuming that the SQL Server you are connecting to is a separate box?

    If the above two assumptions are correct you are trying to use delegation to connect to the SQL Server.  To do this you need to complete some configuration in Active Directory - this is documented in the following articles:

    1.      Designing Distributed Applications with Microsoft Visual Studio .Net – ASP.NET Delegation - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconaspnetdelegation.asp

    2.      HOW TO: Configure an ASP.NET Application for a Delegation Scenario - http://support.microsoft.com/default.aspx?scid=kb;en-us;810572

    3.      INF: SQL Server 2000 Kerberos support including SQL Server virtual servers on server clusters - http://support.microsoft.com/default.aspx?scid=kb;en-us;319723

    4.      HOW TO: Troubleshoot Kerberos-Related Issues in IIS - http://support.microsoft.com/default.aspx?kbid=326985

    Hope this helps.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply