Unable to connect to database; Caused by: Unable to open database connection. I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property

Document created by sheng_liao462475 Employee on Sep 7, 2018Last modified by sheng_liao462475 Employee on Sep 7, 2018
Version 2Show Document
  • View in full screen mode

Error

When trying to connect to MS SQL Server database via NTLM windows authentication, the below error occurs.

 

Unable to connect to database; Caused by: Unable to open database connection. I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. 

 

Error Stack Trace:

SEVERE [com.boomi.connector.TestConnectionMessageHandler executeRequest] Connection Failed :
com.boomi.connector.ConnectorException: Unable to connect to database
at com.boomi.connector.database.browse.DatabaseBrowser.testConnection(DatabaseBrowser.java:124)
at com.boomi.connector.custom.CustomConnectorBrowseAction.connect(CustomConnectorBrowseAction.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.boomi.util.ClassUtil$InvokerWithClassLoader.invoke(ClassUtil.java:369)
at com.sun.proxy.$Proxy39.connect(Unknown Source)
at com.boomi.connector.factory.ConnectorManager$BrowseActionTracker.connect(ConnectorManager.java:1019)
at com.boomi.connector.TestConnectionMessageHandler.executeRequest(TestConnectionMessageHandler.java:40)
at com.boomi.connector.BaseConnectorMessageHandler.handle(BaseConnectorMessageHandler.java:111)
at com.boomi.container.core.MessagePollerThread$BaseTask.handleMessage(MessagePollerThread.java:726)
at com.boomi.container.core.MessagePollerThread$AsyncTask.run(MessagePollerThread.java:821)
at com.boomi.container.util.SimpleSyncExecutorService$TaskRunner.run(SimpleSyncExecutorService.java:179)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.boomi.connector.ConnectorException: Unable to open database connection. I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at com.boomi.connector.database.DatabaseGetConnection.getConnection(DatabaseGetConnection.java:33)
at com.boomi.connector.custom.CustomGetConnectionConnectorAction.getConnection(CustomGetConnectionConnectorAction.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.boomi.util.ClassUtil$InvokerWithClassLoader.invoke(ClassUtil.java:369)
at com.sun.proxy.$Proxy40.getConnection(Unknown Source)
at com.boomi.connector.factory.ConnectorManager.getConnection(ConnectorManager.java:607)
at com.boomi.connector.database.browse.DatabaseBrowser.getDatabaseConnection(DatabaseBrowser.java:136)
at com.boomi.connector.database.browse.DatabaseBrowser.testConnection(DatabaseBrowser.java:119)
... 16 more
Caused by: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:611)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at com.boomi.connector.database.pool.DatabaseConnectionManager.getSoloConnection(DatabaseConnectionManager.java:137)
at com.boomi.connector.database.pool.DatabaseConnectionManager.getConnection(DatabaseConnectionManager.java:89)
at com.boomi.connector.database.DatabaseGetConnection.getConnection(DatabaseGetConnection.java:28)
... 26 more
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1894)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:584)
... 32 more

 

Cause

The error indicates the ntlmauth.dll file are not being recognized by the atom/molecule/cloud. It is either because the .dll file is not being placed at the right location or the .dll file is invalid.

 

Solution

Follow this article to configure the database connection.

Make sure the ntlmauth.dll file is being placed under java_installation/jre/bin folder, and restart the atom/molecule/cloud afterwards.

For example, if you are using the jre that comes with the atom installation, the .dll file should be placed under <atom_installation>/jre/bin folder.

If the error still persists, add the below line in atom.vmoptions file and restart the atom.

 

-Djava.library.path=<java_installation>\jre/bin; 

If this still doesn't solve the issue, double check if the .dll file is valid.

 

Attachments

    Outcomes