How to use Integrated Authentication of MS SQL Server with BusinessConnect ?
Article ID: KB0092680
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | - |
| Not Applicable | - |
Description
Resolution:
The JDBC driver supports the use of Type 2 integrated authentication on Windows operating systems through the integratedSecurity connection string property.
To Make use of this feature with BusinessConnect Follow below steps.
(1) Download MS SQL server jdbc driver from Microsoft website. Extract the downloaded zip file.
Copy ‘sqljdbc_auth.dll’ file to <tibco-home>\tpcl\5.6\bin directory.
Copy ‘sqljdbc.jar’ file to <tibco-home>\tpcl\5.6\jdbc directory.
(2) In your MS SQL server security configuration setup windows security with domain user.
(3) Set up TIBCO Administrator server windows services to start with Windows domain user/password as in above step.
(4) In JDBC connection property :
Select Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL : jdbc:sqlserver://<host>:<port>databaseName=<dbname>integratedSecurity=true;
(Please note ‘;integratedSecurity=true;’ appended at the end.
User Id : not needed. (Anything entered here will be ignored)
Password: not needed. (Anything entered here will be ignored)
Try test connection to make sure it is successful.
(5) Undeploy/Deploy BusinessConnect with following changes.
Go to : Application Management - BusinessConnect – Configuration
Edit Service Instance: Single Server
Process Configuration
NT Service section : enable as NT service with Windows domain user as in step (2) and (3).
(6) Start BC Engine as Windows Service.
For more details on Integrated Authentication of MS SQL Server follow the url below.
http://msdn.microsoft.com/en-us/library/ms378428.aspx
URL to download jdbc driver .
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
Note : All url listed above may change over time.
: Please refer to Microsoft website listed above for right version of sqljdbc.jar and sqljdbc_auth.dll file for your operating system and JDK.
The JDBC driver supports the use of Type 2 integrated authentication on Windows operating systems through the integratedSecurity connection string property.
To Make use of this feature with BusinessConnect Follow below steps.
(1) Download MS SQL server jdbc driver from Microsoft website. Extract the downloaded zip file.
Copy ‘sqljdbc_auth.dll’ file to <tibco-home>\tpcl\5.6\bin directory.
Copy ‘sqljdbc.jar’ file to <tibco-home>\tpcl\5.6\jdbc directory.
(2) In your MS SQL server security configuration setup windows security with domain user.
(3) Set up TIBCO Administrator server windows services to start with Windows domain user/password as in above step.
(4) In JDBC connection property :
Select Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL : jdbc:sqlserver://<host>:<port>databaseName=<dbname>integratedSecurity=true;
(Please note ‘;integratedSecurity=true;’ appended at the end.
User Id : not needed. (Anything entered here will be ignored)
Password: not needed. (Anything entered here will be ignored)
Try test connection to make sure it is successful.
(5) Undeploy/Deploy BusinessConnect with following changes.
Go to : Application Management - BusinessConnect – Configuration
Edit Service Instance: Single Server
Process Configuration
NT Service section : enable as NT service with Windows domain user as in step (2) and (3).
(6) Start BC Engine as Windows Service.
For more details on Integrated Authentication of MS SQL Server follow the url below.
http://msdn.microsoft.com/en-us/library/ms378428.aspx
URL to download jdbc driver .
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
Note : All url listed above may change over time.
: Please refer to Microsoft website listed above for right version of sqljdbc.jar and sqljdbc_auth.dll file for your operating system and JDK.
Issue/Introduction
How to use Integrated Authentication of MS SQL Server with BusinessConnect ?
Feedback
Yes
No
Powered by
