How to configure Windows Authentication for MS SQL data source adapter in TIBCO Data Virtualization?
book
Article ID: KB0073488
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All Supported Versions
Description
The article explains the process of configuring MSSQL data source adapter in TDV Studio using the Windows Authentication method. This method can be helpful when multiple MSSQL server instances with Windows authentication needs to be configured.
Environment
All Supported Operating Systems
Resolution
The below JDBC properties need to be added in the Advanced Tab of the MSSQL data source adapter along with the basic configurations in the TDV Studio:
1. domainName: domain name 2. integratedSecurity: true 3. authenticationScheme: NTLM
Issue/Introduction
This article explains the steps to configure Windows Authentication for the built-in MS SQL data source adapter in TIBCO Data Virtualization.