CABI - Reports Failing - UIM Datasource Test Connection fails - Login failed for user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

Symptoms may include:

• UIM Summary and UIM Summary Saas dashboards do not display data 

• CABI Reports fail with "Datasource Connection Failed" error - unable to run any reports

• Reports fail from both OC and directly within CABI

UIM Datasource Test Connection fails with error below:

java.sql.SQLInvalidAuthorizationSpecException: [TibcoSoftware][SQLServer JDBC Driver][SQLServer]Login failed for user '[email protected]'. at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1075) at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at tibcosoftware.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at 

Environment

• CABI 8.00 configured with a domain service account (non-SQL user)

Cause

• Default JDBC Driver settings do not work properly in this scenario

Resolution

1. Login to cabi directly using superuser with superuser (default) as the password 

http://<XX.XX.XX.XX>:<port>/cabijs/login.html 
or
http://<cabitest.example.com>:<port>/cabijs/login.html 

2. In the Home page click on Data Sources

3. The UIM Datasource will display

4. Hover the mouse over the UIM Datasource, right click and select edit. 

Set JDBC Driver as shown below (standard connector with cabi probe 8.00.)

5. Change the  JDBC URL as followed (remove tibcosoftware)

From:

jdbc:tibcosoftware:sqlserver://<uimdb.example.com>:1433;databaseName=CA_UIM;integratedSecurity=true

To:

jdbc:sqlserver://<uimdb.example.com>:1433;databaseName=CA_UIM;integratedSecurity=true

Note:  In some cases, the original URL does not already contain "integratedSecurity=true" even though Domain authentication is used - when making this change you will need to add it to the end of the URL.

6. Run the Test Connection and validate connectivity

7. Click Save

8. Validate that UIM Summary and UIM Summary Saas dashboards display data and/or reports can be run.