JDBC URL Connection to a Named Instance

book

Article ID: 34994

calendar_today

Updated On:

Products

DX Infrastructure Management 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: