IIS 5 & IIS 6
Looking for a tool that will diagnose where the connection is failing...
Last post Oct 17, 2007 03:34 PM by mvolo
Oct 17, 2007 10:34 AM|Tharriso|LINK
I have a web app that is load balanced between two servers, but one of the servers seems to be having issues authenticating with one of the databases it connects to. The files are being replicated, so I know it's not a bad connection string. I am able
to successfully make a test ODBC connection from the web server using all of the connection strings. But when I load the site from one of the web boxes and try to authenticate against the database, it fails. Is there any tool that will trace the login process
and tell me where/why it is failing?
Oct 17, 2007 03:34 PM|mvolo|LINK
There are a couple options.
First, you can monitor the queries at the SQL server box using "Sql Profiler".
Second, you should try to figure out what exactly fails on the web server when the authentication attempt fails. It could be that the authentication attempt in the DB fails, but it also could be that your application or the authentication code is failing.
You can use the ASP.NET (assuming this is ASP.NET) health monitoring feature to emit events whenever exceptions occur, or whenever Membership APIs (if this is a Membership-based system) fails to authenticate the user. You can direct these events to the eventlog
or an email report to you. For more info about health monitoring, see
IIS Core Server
Visit mvolo.com for more inside information on IIS7, IIS and ASP.NET