How to configure the ActiveMatrix Adapter for Database to connect to the Microsoft SQL Server using Windows Authentication.
Article ID: KB0081836
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.2.0 hotfix 02 |
Description
TIBCO ActiveMatrix Adapter for Database supports connecting to the Microsoft SQL Server using Windows Authentication.
Issue/Introduction
How to configure TIBCO ActiveMatrix BusinessWorks Plug-in for Database 7.2.0 Hotfix-02 to connect to the Microsoft SQL Server using Windows Authentication.
Environment
Product: TIBCO ActiveMatrix Adapter for Database
Version: 7.2.0 Hotfix 02
OS: All Support Plagform
Resolution
Software requirement:
TIBCO ActiveMatrix Adapter for Database 7.2.0 Hotfix 02
TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio ) 1.3.0 Hotfix 01 (For BW 6 environments only.)
Configuration requirement:
1). Add "authenticationMethod=type2;loadLibraryPath=<Path of the DB drivers>" to the end of the JDBC URL in the Designer or BusinessStudio.
For example: authenticationMethod=type2;loadLibraryPath=C:\tibco\tpcl\5.10\jdbc
2). Leave the User Name and the Password empty.
3). Run Test Connection to confirm the connection to the database succeeds.
TIBCO ActiveMatrix Adapter for Database 7.2.0 Hotfix 02
TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio ) 1.3.0 Hotfix 01 (For BW 6 environments only.)
Configuration requirement:
1). Add "authenticationMethod=type2;loadLibraryPath=<Path of the DB drivers>" to the end of the JDBC URL in the Designer or BusinessStudio.
For example: authenticationMethod=type2;loadLibraryPath=C:\tibco\tpcl\5.10\jdbc
2). Leave the User Name and the Password empty.
3). Run Test Connection to confirm the connection to the database succeeds.
Feedback
Yes
No
Powered by
