I have SQL Server Integrated Security Working on window

BLOMASKY

For others who want to use that instead of having a Username / Password

1) Copy the appropriate sqljdbc_auth.dll (either the X86 or the X64) to your path. (no, it does not work putting into the Aware/Tomcat/Lib folder. So I just copied it to the Windows folder). This file is located in:
<installation directory>\sqljdbc_<version><language>\auth\

2) Remove UserName and Password from the JDBC string and replace it with: IntegratedSecurity\=true;

3) Stare Aware and smile

(of course, this only works under Windows.)

Jaymer

Bruce,
I guess the reason for doing this is that normally, the SA userid and password can be seen in one of the profs files? (which is def. a security leak)

BLOMASKY

Actually, I HAVE to do this to call a SSIS package that is stored within the DB. You can only do that with Integrated security. (I have a need to call this, which extracts a SQL (ok, BO) and exports it to a CSV.

Bruce