VERIFIED SOLUTION i
X

Resolve issue where the MSSQL database cannot connect to Spectrum

Issue

While trying to configure a MSSQL database for use with the Spectrum "Read from DB" stage, the "Test" connection failed with the following error message:

The connection test failed. 
Reason: Exception while trying to connect to DataSource: <database connection>: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. 
User-added image
 

Cause

Customer is using Windows Authentication for MSSQL, and it was not configured for use with Spectrum

Resolution

UPDATED: August 2, 2017


Customer needed to download the "ntlmauth.dll" and place it into the "\Spectrum\java64\jre\bin" directory.

Environment Details

Product Feature: Printing-General Output

 

Downloads

  • No Downloads