locked
Has some problems when configuring windows authentication in IIS 7 RRS feed

  • Question

  • Recently I'm working on a project. This project is deployed on Windows server 2008 R2 and using IIS7.

    It's using classic ASP, not ASP.NET. 

    In this project we want to use Windows Authentication for application login and SQL connection. 

    The problem is when we enable Windows Authentication, the application can't connect to the SQL server. The error message said " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.". If we enable Basic Authentication the application will use the current logon user to connect the SQL server.

    The expected result is after the Windows Authentication is enabled, when somebody logon to the application, the application will use the application pool account to connect to the SQL server not the current logon user or anonymous user.

    Does anybody has any idea about this?


    Jacob.Gu

    • Moved by Barry Wang Wednesday, September 10, 2014 5:32 AM
    Tuesday, September 9, 2014 8:38 AM

Answers

  • Hello Jacob.Gu,

    This forum supports .NET installation not IIS setting, please reopen a new post on the following forum:

    http://forums.iis.net/

    Regards,



    Barry
    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Jacob.Gu Friday, September 12, 2014 7:08 AM
    Wednesday, September 10, 2014 5:31 AM

All replies

  • Hello Jacob.Gu,

    This forum supports .NET installation not IIS setting, please reopen a new post on the following forum:

    http://forums.iis.net/

    Regards,



    Barry
    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Jacob.Gu Friday, September 12, 2014 7:08 AM
    Wednesday, September 10, 2014 5:31 AM
  • I have moved this question to the IIS forum.

    Jacob.Gu

    Friday, September 12, 2014 7:07 AM