Topic: Howto connect to SQLServer with integratedsecurity

I run into a problem with integrated security I wish to share with the rest of you. Integrated security will only work if you're on a windows box.

If you're using integrated security you have to configure this in two places.
First you need to modify the java command in your datacleaner.bat.
Add the following parameter

–Djava.libary.path=Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\auth\x86\

Afterwards add the parameter

integratedSecurity=true

in your connectionString. You can leave usr/pwd blank.