JDBC connection to MS SQL Server with Windows NTLM Authentication 
Author Message
 JDBC connection to MS SQL Server with Windows NTLM Authentication

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.



Tue, 26 Oct 2004 02:04:47 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. attempts to logon using SQL Server authentication treated as Windows authentication

2. SQL Server Authentication vs. Windows Authentication

3. SQL Server Windows Authentication : How to connect a different user then the current Windows login user

4. ASP NTLM Authentication

5. no NTLM or Kerberos Authentication

6. JDBC Connection to MS SQL Server 2000

7. Connection/JDBC/MS SQL Server

8. ODBC via MS Access2000, Windows 2000 workstation, fails to use SQL Authentication

9. OH-COLUMBUS-50088--ORACLE-MS SQL Server-UNIX-Windows NT-MS Office-Client/Server-

10. SQL Permissions with Trusted Connection/Windows Authentication

11. SQL Permissions with Trusted Connection/Windows Authentication

12. OH-COLUMBUS-50088--ORACLE-MS SQL Server-UNIX-Windows NT-MS Office-Client/Server-


 
Powered by phpBB® Forum Software