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=<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.

Hi,

On Windows is it not:

-Djava.library.path="C:/Microsoft SQL Server JDBC Driver 3.0/sqljdbc_3.0/enu/auth/x86/"

...use double quotes if there are spaces in path name and use """/""" instead of """\""" as path separator.