Greetings,
I am building an ASP application that uses IIS Integrated Security and ADSI. I also would like to use SQL Integrated Security and the IIS box. There is no option to use both together.
If I disable the anonymous user, I can obtain the login name, but I cannot connect to the SQL server. If I enable the anonymous user, I can connect to the SQL server, but cannot obtain the login name!
One idea I had is to build a COM object that will act as the interface between ASP and SQL, this COM object can be set to "Run As" the IUSR and thus able to connect to the SQL server. The only major problem with that is that we do not own Visual Basic.
Does anyone know another way this can be done?
Bontebok
I am building an ASP application that uses IIS Integrated Security and ADSI. I also would like to use SQL Integrated Security and the IIS box. There is no option to use both together.
If I disable the anonymous user, I can obtain the login name, but I cannot connect to the SQL server. If I enable the anonymous user, I can connect to the SQL server, but cannot obtain the login name!
One idea I had is to build a COM object that will act as the interface between ASP and SQL, this COM object can be set to "Run As" the IUSR and thus able to connect to the SQL server. The only major problem with that is that we do not own Visual Basic.
Does anyone know another way this can be done?
Bontebok
