IIS 5 & IIS 6
Good tool for troubleshooting issues between IIS and SQL servers?
Last post May 05, 2008 02:58 PM by tomkmvp
May 05, 2008 11:31 AM|Tharriso|LINK
We have a web application that has worked fine for a while now, but recently it is unable to authenticate any users to the database. I have verified the connection string is correct, and I am able to successfully test an ODBC connnection from the web to
the sql server. I have also verified the firewall is open. What is happening is that the login page for this app comes up, but when trying to log in it says the username was not found in the database, even though it is there. We have tried this with several
different users and our test logins and none seem to work suddenly. So is there a good tool I can run from a browser or the web server to identify where the problem is? Thanks!
May 05, 2008 12:22 PM|tomkmvp|LINK
So you're saying this is custom authentication performed by the appliocation, where it checks user input with a text box and then queries the database to see if that text matches a record in a table?
May 05, 2008 01:47 PM|Tharriso|LINK
Thanks for the reply Tom, that is correct. The authentication to the app is controlled by the database. Basically what I'm looking for is something to prove that the application is actually getting to the database and that the problem is actually an authentication
issue and not a connectivity issue.
May 05, 2008 02:58 PM|tomkmvp|LINK
Be careful when you say authentication because someone may mistake it as an actual authentication/security problem connecting with the database. Your problem seems to be code related in that the select query no longer works correctly (doesn't find the submitted
username in the table). What I would suggest is to put some debugging code into page - perhaps to Response.Write out the SQL that is getting passed to the database. You could then check that SQL/paste it into a query tool to see if it's valid or what you
expect to see. What platform is this on?