How to configure TIBCO API Exchange Gateway to authenticate with an SQL Server using Active Directory.

How to configure TIBCO API Exchange Gateway to authenticate with an SQL Server using Active Directory.

book

Article ID: KB0093118

calendar_today

Updated On:

Products Versions
TIBCO API Exchange -
Not Applicable -

Description

Description:
How to configure TIBCO API Exchange to authenticate with an SQL Server DB using Active Directory.

Issue/Introduction

How to configure TIBCO API Exchange Gateway to authenticate with an SQL Server using Active Directory.

Resolution

In the asg_cl.properties, append the property integratedSecurity=true to the URL. Leave the username and password blank.

Example.


tibco.clientVar.CL/Database/Username=
tibco.clientVar.CL/Database/Password=
tibco.clientVar.CL/Database/Url=jdbc:sqlserver://x.x.x.x:1433;databaseName=asgstat;integratedSecurity=true

Install Central Logger as a Windows service and set Log On account to the AD account. Copy the file sqljdbc_auth.dll to a directory on the system path.
Powered by Wolken Software