How to connect to SQL Server using SQL Native Driver with Windows Authentication.
Article ID: KB0084851
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
Steps for connecting to SQL Server using SQL Native Driver with Windows Authentication.
1). Download the SQL Drivers.
2). Extract the contents of the download driver and copy “sqljdbc_auth.dll” inside <installation directory>\sqljdbc_<version>\<language>\auth\ to the \Windows\System32 folder.
3). Add sqljdbc4.jar to the TIBCO Installation\tpcl\<version>\jdbc .
4). Use the URL with integratedSecurity=true;
jdbc:sqlserver://DBANC01:1433;databaseName=PioneerAVM;integratedSecurity=true;
Steps for connecting to SQL Server using SQL Native Driver with Windows Authentication.
1). Download the SQL Drivers.
2). Extract the contents of the download driver and copy “sqljdbc_auth.dll” inside <installation directory>\sqljdbc_<version>\<language>\auth\ to the \Windows\System32 folder.
3). Add sqljdbc4.jar to the TIBCO Installation\tpcl\<version>\jdbc .
4). Use the URL with integratedSecurity=true;
jdbc:sqlserver://DBANC01:1433;databaseName=PioneerAVM;integratedSecurity=true;
Issue/Introduction
How to connect to SQL Server using SQL Native Driver with Windows Authentication.
Feedback
Yes
No
Powered by
