Error : "java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded"

Symptom

When running a 360eyes job (from the CMC or the GUI), the following error is received:


"The program failed to run and supplied the following information: com.gbs.a.h: Error during Database update/migration: com.gbs.a.h: Error during init/update database: liquibase.exception.JDBCException: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.This functionality is available only under "Microsoft Windows" line of Operating systems."

Environment

  • 360Eyes
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • SAP BusinessObjects Business Intelligence 4.2
  • SAP BusinessObjects Business Intelligence 4.3

Cause

This error occurs because CMC and the GUI might not use the same java.exe.


Resolution

In order to use SSO, the ntlmauth.dll (32-bit or 64-bit) must be copied to any folder listed in the system path (the PATH environment variable on Windows environments only).

The file can be downloaded using this link: Download File.
Select the file version matching the JVM version running on your system. The bit version depends on the JRE (and NOT the OS, because you can use a 32bit JRE on a 64bit OS and so in this case you need the 32bit dll.
  • x86 if using a 32-bit JVM
  • x64 if using a 64-bit JVM

Then, when configuring the 360Eyes DB, you can leave the user & password fields empty to enable the SSO mode.

Keywords
SSO, SQLServer

Product

Product or Product version

  • 360Eyes

Languages

  • English

Last updated almost 2 years ago