Integrated Security in Tomcat 6.0.16

Hi

Until now, I've always used sql server authentication in my Java apps using
the 1.2 SQL JDBC driver. Now, for reasons beyond my control, I have to run
certain applications using integrated security. Shouldn't be a problem I
figured since my wrapper classes can already handle both.. and so I tested
one application after another. Individually, they all work just fine. After
running the commandline apps, I tested the two applications running on
Tomcat.. on my dev box, all was fine. Then I deployed them onto a test
server. Reconfigured Tomcat to run under a Windows account instead of SYSTEM.
Then I tested application 1. No problems so far. Then I went to application 2
and then I couldn't connect to the database.

I got the usual
Reason: Dieser Treiber ist nicht für integrierte Authentifizierung
konfiguriert.
(no idea why this comes up in German.. my locale might be de-ch but the
machine is entirely set up in English).. but that error says "This driver has
not been configured for integrated authentication".

I usually get that error if I forgot to put sqljdbc_auth.dll into the path.
But.. on that box, that file is there. I restarted Tomcat, and now
application 2 ran fine and application 1 didn't connect to the database
anymore. It seems that whichever application is started first can connect,
and the rest of the apps cannot.

Just to be on the safe side I configured Tomcat to run using the local
administrator but the issue remains.

I even went as far as to add the sqljdbc_auth.dll file to the lib directory
of tomcat as well as the lib directory of each of the deployed webapps but to
no avail.

So, how I get both webapps to successfully connect to the database (sql
server 2005 sp2 express by the way.. wlll be sql server 2000 with latest sp
in the productive environment)?
.

Relevant Pages