How to setup alarm_enrichment connection_url for the cmdb with Windows Authentication.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The data_engine is using Windows Authentication to connect to the MS SQL Server hosting the UIM database, and when the connection_url is configured as per the documentation it fails to connect with this error in the alarm_enrichment log:
[main, alarm_enrichment] (1) error, Failed to connect to database: Login failed for user

Environment

Release : 20.3

Component : UIM NAS

Cause

It is using the account as a MS SQL Server user instead of using Windows Authentication. 

Resolution

Add IntegratedSecurity=true to the end of the connection_url.

Additional Information

Document page:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/nas-alarm-server/nas-versions-4-4-4-7/v4-6-alarm-enrichment-raw-configuration.html#concept.dita_0d87c631c65c674d3722f96e28a12090bc51cad5_SettingupcmdbsEnvironment

Sample:
connection_url = jdbc:sqlserver://172.17.8.12:1433;DatabaseName=CA_UIM;IntegratedSecurity=true

<enrichment-source>
    <cmdbs>
        <os_enricher>
            active = true
            connection_url = jdbc:sqlserver://<database server IP or name>:1433;DatabaseName=<UIM DB name>;IntegratedSecurity=true
            user = UserName or if AD is used it is DomainName\UserName
            password = kdf0iniSjH+/sNGf8ieU1A==_encrypted
            query = select name,ip,os_type from cm_computer_system where name=?
            population_query = select name,ip,os_type from cm_computer_system
        </os_enricher>
    </cmdbs>
</enrichment-source>

Multiple data sources can be defined via changing the name of the subsection. 
      <os_enricher_1>
   
Default from the cfg:
<enrichment-source>
   <cmdbs>
      <os_enricher>
         active = false
         connection_url = jdbc:mysql://127.0.0.1:3306/DBname
         user = root
         password = password_gets_enrcyrpted_on_first_use
         query = select name,ip,os_type from cm_computer_system where name=?
         population_query = select name,ip,os_type from cm_computer_system
      </os_enricher>
   </cmdbs>