Summary:
How to specify JDBC URL in nas.cfg for alarm_enrichment cmdb source when connecting to a MS SQL Server named instance.
Environment:
Unified Infrastructure Management (UIM)
MSSQL backend database
Instructions:
When connecting to a MS SQL Server named instance in alarm_enrichment cmdb source, specify connection_url as:
connection_url = jdbc:sqlserver://10.192.10.52:<Port_Number>;DatabaseName=<DB_Name>
example:
connection_url = jdbc:sqlserver://10.192.10.52:1444;DatabaseName=nimsoftslm
When you specify the port, it ignores the "InstanceName" parameters so there is no need to specify that separately.