I have been searching the internet for a Web application solution that
allows JDBC connections with Windows Authentication to MS SQL Server
with no avail.
Here is the scenario:
* Web application with IIS-Tomcat.
* Client browser(IE) authenticates with IIS using Windows
Authentication.
* Somehow, the servlet running in Tomcat uses the credentials
established in the IIS authentication to creat a connection to SQL
Server that only allows Windows Authentication.

I'm not sure if this is the right approach, but it is logical. I heard
that you can somehow achieve this with ASP.
I have two major problems with the above approach:
1. How do we pass the authentication information from IIS to Tomcat.
2. How does the servlet make a connection with NTLM windows
authentication to the database. I don't think any type 4 JDBC drive
can achive this (the JDBC driver provided by MS doesn't). Is there
possibly a type 3 JDBC driver available that supports this?

The JDBC-ODBC bridge may provide a solution for a client side Java
application. But the ODBC on the server side will only provide the log
in for whoever is running Java.

Any thoughts?

Thanks.