integratedSecurity issues with Microsoft SQL Server 2005 JDBC Driver

I am using Microsoft SQL Server 2005 JDBC Driver to connect to SQL Server 2000 database, I am using the following connection URL

boolean iSecurity = true;

String connectionUrl = "jdbc:sqlserver://machine_name:1433;" + "databaseName=dbname;integratedSecurity=" + iSecurity;

I am getting the following error.

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

How do I resolve it? I have the following set

VMOPTIONS = -Xrs -Djava.compiler=NONE -Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth\x86\sqljdbc_auth.dll

Any help will be highly appreciated.

Regards

Arup

Hi Arup,

Try the following instead:

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth\x86\

The java.library.path JVM argument takes the location of a directory and not the .dll file itself.

Regards,

Jaaved Mohammed