Here's a summary of how to setup integrated authentication between Novell's JDBC Driver and Microsoft SQL Server 2005.

First, you should  use the remote loader because the 2005 JDBC driver becomes a native driver (type 2) when you tell it to use sqljdbc_auth.dll for integrated authentication (read it's no longer Java so any bugs in said dll will abend the eDirectory process if it proves to be buggy).

#) Copy sqljdbc_auth.dll into the root-level remote loader directory (e.g., c:\novell\remote_loader).
#) Restart the remote loader service.
#) The remote loader process has to run as the Windows user authenticating to the database.  In this case, I created a user named Jason on both machines w/ the same password. Keep in mind, I'm not using a domain controller.  The simplest way to do this is to login as the user and start the remote loader under the current session.
#) Using Microsoft SQL Server Management Studio (Enterprise Manager + Query Analyzer all rolled-up in one), manually assign similar permissions you'd give to the "idm" user when using SQL Server authentication.  For the sake of time, I made the Jason user a minor deity by granting him liberal permissions.
#) There's a limitation in the existing Novell JDBC driver in that it requires a username.  To work around this, go ahead and provide one even though it won't be used at authentication time.
#) Set the integratedSecurity property in the JDBC URL to true.  If you don't know what this means, consult Microsoft's documentation and it will make sense.
#) Start the driver as usual and wallah, it works!

Thanks to Jason Elsberry

!!Windows 2000 MS SQL
#. Put jtds.jar in C:NovellRemoteLoader\lib
#. Put ntlmauth.dll in C:NovellRemoteLoader
#. JDBC Driver config:
**Authentication ID: idm (windows account)
**Authentication context: jdbc:jtds:sqlserver://10.1.1.1:1433/bkdb;domain=TEST
**Remote loader connection parameters: hostname=10.1.1.1 port=8090
**Application password: novell


!! More Information
There might be more information for this subject on one of the following:
[{ReferringPagesPlugin before='*' after='\n' }]