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 over 2 years ago