Native SPPI library Dll file for Windows required for MSSQL connection

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Customer intends to configure Kerberos Authentication with his SQL Server Database.

https://docs.automic.com/documentation/webhelp/english/ALL/components/TERMA/latest/AAI%20Guides/Content/AAI_Topics/Chapter_14_JAWS_Using_Kerberos_Authentication_with_SQL_Server_278.htm:

""Windows Specific Installation
In order for the Kerberos Authentication to SQL Server (jTDS Single Sign-On) to work on Windows platforms, an additional native SPPI library (DLL file) must be loaded. This library can be requested from the Broadcom technical support. This additional DLL file must be placed in the Windows\System32 folder on the Windows server machine. The Windows user making the changes must have Administrator permissions.""

 

Environment

Automic Automation Intelligence 6.2 

Resolution

The library that the customer must use is the ntlmauth.dll which is use to connect to a MSQL Server with Windows Authentication.