JDBC URL Connection to a Named Instance

Article Id: 34994

Status: Published

Updated On: 14-02-2018 07:40

Legacy Id: TEC000003846

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES

Issue/Introduction:

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.

Environment:

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: