How to connect SQL Server DB with NTLM?
Article ID: KB0092402
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
I understand you are referring to connecting to MS SQL Server Windows Integrated Authentication (NTLM).
If so, you can achieve it using TIBCO JDBC driver specifying type2 authentication and location to 'DDJDBCAuth04.dll' library in your JDBC connection URL.
In TRA 5.5 that library is located under <tibco_home>\tpcl\5.5\jdbc\lib
Sample JDBC URL using type2 authentication and TIBCO JDBC SQLServer driver will look like:
jdbc:tibcosoftwareinc:sqlserver://<host>:<port#>databaseName=<databaseName>authenticationMethod=type2;loadLibraryPath=C:\\tibco\\tpcl\\5.5\\jdbc\lib
Also, please refer to document Jdbcref.pdf available at path <tibco_home>\tpcl\5.5\jdbc\books\jdbc\Jdbcref
I understand you are referring to connecting to MS SQL Server Windows Integrated Authentication (NTLM).
If so, you can achieve it using TIBCO JDBC driver specifying type2 authentication and location to 'DDJDBCAuth04.dll' library in your JDBC connection URL.
In TRA 5.5 that library is located under <tibco_home>\tpcl\5.5\jdbc\lib
Sample JDBC URL using type2 authentication and TIBCO JDBC SQLServer driver will look like:
jdbc:tibcosoftwareinc:sqlserver://<host>:<port#>databaseName=<databaseName>authenticationMethod=type2;loadLibraryPath=C:\\tibco\\tpcl\\5.5\\jdbc\lib
Also, please refer to document Jdbcref.pdf available at path <tibco_home>\tpcl\5.5\jdbc\books\jdbc\Jdbcref
Issue/Introduction
How to connect SQL Server DB with NTLM?
Feedback
Yes
No
Powered by
