Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Education
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
DX Infrastructure Management
Private Community
Community Home
Threads
Library
Events
Members
Back to Library
Tech Tip: CA UIM / CABI - cabi_external Windows Authentication Configuration / UIM Datasource test connection fails
2
Recommend
Jun 27, 2018 11:49 AM
Ryan Dunn
Issue:
After installing the cabi_external probe and configuring the cabi_url key as per the documentation below, the cabi_external probe now starts.
Install or Upgrade for an External CA Business Intelligence JasperReports Server
Now the cabi_external probe is running, I attempted to enable Windows Authentication using the below documentation.
(Microsoft SQL Server Windows Authentication Only) Configure Windows Authentication
CABI Dashboards do not work in the CABI WebConsole or UMP and Users do not sync.
Signed into the CABI WebConsole -> Data Sources -> Selecting the "UIM Datasource" -> Right Click, Edit -> Test Connection fails.
The "UIM JNDI Datasource" also fails to connect.
Environment:
- UIM 8.51, Windows environment with Windows Authentication enabled.
- All machines are running in the same DOMAIN and all services on the CABI, UIM, UIM Database servers are started with the same domain user.
- Jasper Reports Server 6.3.0
- cabi_external probe v3.20
- uim_core_dashboards v2.40
- uim_unified_reporter v1.02
- uim_cabi_health_report_pack v1.20
- uim_unified_reporter_pack v1.02
- ump_cabi package v3.20 (deployed to the ump robot)
Resolution:
Ensure the following Datasource settings are in place:
1. Sign into the CABI WebConsole -> Data Sources -> Select the "UIM Datasource" -> Right Click, Edit
- Select the "MS SQL Server 2005 (com.microsoft.sqlserver.jdbc.SQLServerDriver)" driver in the "JDBC Driver" field.
- Ensure the "Host", "Port", "Database" fields are correct.
- Add the same domain username/password to the "User Name" and "Password" fields.
- Add the following to the end of the "URL" field: ";integratedSecurity=true" example:
jdbc:sqlserver://localhost:1433;databaseName=dbname;integratedSecurity=true"
2. Save the UIM Datasource update and test the connection.
In this scenario, the UIM Datasources still failed.
3. We ran a search on the CABI server and found the sqljdbc_auth.dll file in the following locations:
- CA\SC\CA Business Intelligence\apache-tomcat\bin
- CA\SC\CA Business Intelligence\java\bin
- CA\SC\CA Business Intelligence\jre\lib
4. The sqljdbc_auth.dll file should only be in the apache-tomcat\bin directory (CA\SC\CA Business Intelligence\apache-tomcat\bin)
5. Removed the sqljdbc_auth.dll from the other locations, Restarted the "CA Business Intelligence Tomcat" Service and tested the UIM Datasource connections. After this, both UIM Datasources successfully connected, the UIM out of the box dashboards loaded in both the CABI WebConsole and UMP.
KB Link:
CA UIM / CABI - cabi_external Windows Authenticati - CA Knowledge
Statistics
0 Favorited
13 Views
0 Files
0 Shares
0 Downloads
Related Entries and Links
No Related Resource entered.
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic