How to use SQL Server windows authentication with TIBCO ADB adapter?
Article ID: KB0090061
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
Here are the steps which you need to follow:
ADB Design-time settings:
1) MS SQL Server – MS SQL Server 2000 Service Pack 3 or higher
A. Bring up SQL Server Enterprise Manager, right mouse click on (local) and bring up SQL Server Properties dialog.
B. Click General tab and make sure “Production version:” is 8.00.2039 (SP4) or something like that. If your version is 8.00.194 (RTM), then you will need to apply SP 4.
Link for SP 4 -
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en
Download SQL2000-KB884525-SP4-x86-ENU.EXE and install SP 4. Please remember to stop your SQL server before applying the SP.
2) DDJDBCAuth04.dll shared library –
You may get a copy of DDJDBCAuth04.dll from attachment or by downloading and installing DataDirect driver from http://www.datadirect.com.
Place DDJDBCAuth04.dll under C:\tibco\tpcl\5.x\jdbc directory
3) JDBC Connection URL –
Specify JDBC connection URL to use type2 authentication and the path to DDJDBCAuth04.dll shared library.
Ex. “jdbc:tibcosoftwareinc:sqlserver://localhost:1433;databaseName=pubs;authenticationMethod=type2;loadLibraryPath=C:\\tibco\\tpcl\\5.4\\jdbc”
4) JDBC Connection shared resource –
Leave both User and Password fields empty (i.e. blank).
5) Make sure MS SQL Server is configured to support Windows authentication.
A. Bring up SQL Server Enterprise Manager, right mouse click on (local) and bring up SQL Server Properties dialog.
B. Click Security tab and make sure “Authentication:” is “SQL Server and Windows”.
You are now all set to connect to MS SQL Server using TIBCO driver with type2 Windows Authentication.
For more details, please refer to C:\tibco\tpcl\5.4\jdbc\books\jdbc\Jdbcref\jdbcref.pdf, Chapter 6 The Microsoft SQL Server Driver, Authentication.
Note that earlier TIBCO drivers (i.e., prior to TRA 5.4) were not branded with appropriate branding tool. As a result, type2 windows authentication does not work in this case. You will need to ask Release engineers to brand the TIBCO driver again with the new and updated branding tool. All necessary jars are in attached zip.
ADB Runtime:
1) Start the SQL server using the same user as Windows.
2) Make sure the Windows user is the owner of the database.
3) Configure the DSN to use NT Authentication.
4) Set adb.user=<windows login username> in the runtime tra file.
Now you are able to run the agent using windows authentication.
KEYWORDS: SQL SERVER, WINDOWS AUTHENTICATION, JDBC, ODBC.
Here are the steps which you need to follow:
ADB Design-time settings:
1) MS SQL Server – MS SQL Server 2000 Service Pack 3 or higher
A. Bring up SQL Server Enterprise Manager, right mouse click on (local) and bring up SQL Server Properties dialog.
B. Click General tab and make sure “Production version:” is 8.00.2039 (SP4) or something like that. If your version is 8.00.194 (RTM), then you will need to apply SP 4.
Link for SP 4 -
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en
Download SQL2000-KB884525-SP4-x86-ENU.EXE and install SP 4. Please remember to stop your SQL server before applying the SP.
2) DDJDBCAuth04.dll shared library –
You may get a copy of DDJDBCAuth04.dll from attachment or by downloading and installing DataDirect driver from http://www.datadirect.com.
Place DDJDBCAuth04.dll under C:\tibco\tpcl\5.x\jdbc directory
3) JDBC Connection URL –
Specify JDBC connection URL to use type2 authentication and the path to DDJDBCAuth04.dll shared library.
Ex. “jdbc:tibcosoftwareinc:sqlserver://localhost:1433;databaseName=pubs;authenticationMethod=type2;loadLibraryPath=C:\\tibco\\tpcl\\5.4\\jdbc”
4) JDBC Connection shared resource –
Leave both User and Password fields empty (i.e. blank).
5) Make sure MS SQL Server is configured to support Windows authentication.
A. Bring up SQL Server Enterprise Manager, right mouse click on (local) and bring up SQL Server Properties dialog.
B. Click Security tab and make sure “Authentication:” is “SQL Server and Windows”.
You are now all set to connect to MS SQL Server using TIBCO driver with type2 Windows Authentication.
For more details, please refer to C:\tibco\tpcl\5.4\jdbc\books\jdbc\Jdbcref\jdbcref.pdf, Chapter 6 The Microsoft SQL Server Driver, Authentication.
Note that earlier TIBCO drivers (i.e., prior to TRA 5.4) were not branded with appropriate branding tool. As a result, type2 windows authentication does not work in this case. You will need to ask Release engineers to brand the TIBCO driver again with the new and updated branding tool. All necessary jars are in attached zip.
ADB Runtime:
1) Start the SQL server using the same user as Windows.
2) Make sure the Windows user is the owner of the database.
3) Configure the DSN to use NT Authentication.
4) Set adb.user=<windows login username> in the runtime tra file.
Now you are able to run the agent using windows authentication.
KEYWORDS: SQL SERVER, WINDOWS AUTHENTICATION, JDBC, ODBC.
Issue/Introduction
How to use SQL Server windows authentication with TIBCO ADB adapter?
Feedback
Yes
No
Powered by
