The Visualizer cannot connect to the MDB, if it's installed in a Named Instance with the port number included in the instance name.

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

The visualizerMS.log shows the following:

DEBUG - 2024-10-22 17:03:36 [c.b.v.core.db.DBConnectionPoolImpl] - Create connection with connectionURL: 

jdbc:sqlserver://SQL-Server-Name\Instance-Name,Port_Number;database=mdb for dbUserName: mdbadmin
ERROR - 2024-10-22 17:03:52 [c.b.v.core.db.DBConnectionPoolImpl] - Failed to create a connection.
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host SQL-Server-Name, named instance Instance-Name,Port_Number failed. 

Environment

Service Management 17.*

Service Desk 17.*

SDM 17.*

Cause

SQL Server Browser port blocked in firewall.

Resolution

Both the SQL server TCP port and the UDP port 1434 for SQL Server Browser need to be open between the Service Desk server and the SQL server housing the MDB.