This page (revision-1) was last changed on 29-Nov-2024 16:16 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note

Page References

Incoming links Outgoing links
NovellIDMMicrosoftSQLServer2005IntegratedAuthentication
NovellIDMMicrosoftSQLServer2005IntegratedAuthentication

Version management

Difference between version and

At line 1 added 27 lines
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' }]
This page (revision-1) was last changed on 29-Nov-2024 16:16 by UnknownAuthorTop