How to configure MS SQL Server data source connection using Windows Authentication in TIBCO Data Virtualization clustered environment?
Article ID: KB0076808
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
This article explains how to configure MS SQL Server data source connection using the Windows Authentication method in a TDV clustered environment.
Issue/Introduction
How to configure MS SQL Server data source connection using Windows Authentication in TIBCO Data Virtualization clustered environment?
Environment
Windows
Resolution
Let's consider a two-node TDV cluster having node A and node B.
1. Start the TDV server services of both nodes A and B using the same service account details.
To start the services using a service account follow the below steps:
a. Open the "Services" on Windows.
b. Search for TDV server service, right-click on "TDV Server 7.0" and select the "Properties" option.
c. Go to the Log On and select the "This account" button.
d. Enter the account details and click on Apply.
2. Open TDV Studio for one of the cluster nodes and add a new MS SQL data source Adapter.
3. Enter the MS SQL host and database name. Leave the username and password field black.
4. Add the below property to the Advanced tab of the data source in the JDBC URL:
IntegratedSecurity=true
The JDBC URL will look as below:
jdbc:sqlserver://<HOST>:<PORT>;IntegratedSecurity=true;DatabaseName=<DATABASE NAME>
5. Click on create.
NOTE: The MS SQL connection will fail on the cluster nodes whose server services are not running on the Service account used to configure the MS SQL connection.
1. Start the TDV server services of both nodes A and B using the same service account details.
To start the services using a service account follow the below steps:
a. Open the "Services" on Windows.
b. Search for TDV server service, right-click on "TDV Server 7.0" and select the "Properties" option.
c. Go to the Log On and select the "This account" button.
d. Enter the account details and click on Apply.
2. Open TDV Studio for one of the cluster nodes and add a new MS SQL data source Adapter.
3. Enter the MS SQL host and database name. Leave the username and password field black.
4. Add the below property to the Advanced tab of the data source in the JDBC URL:
IntegratedSecurity=true
The JDBC URL will look as below:
jdbc:sqlserver://<HOST>:<PORT>;IntegratedSecurity=true;DatabaseName=<DATABASE NAME>
5. Click on create.
NOTE: The MS SQL connection will fail on the cluster nodes whose server services are not running on the Service account used to configure the MS SQL connection.
Feedback
Yes
No
Powered by
