Alternative way for installing Service Desk on SQL named instance and non-standard port

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

This article provides an alternative method that you can install Service Desk 17.3 with a SQL named instance, if the original installation hits issues with SQL named instance and non-standard port.

Environment

CA Service Desk Manager 17.3

SQL MDB

Resolution

Please perform below steps:

1. Install Service Desk using default SQL instance and standard port and verify it works fine after installation
2. Shutdown SDM and create a named instance and move the mdb to the named instance
3. Change NX.env file @NX_DB_NODE variable:
   @NX_DB_NODE=SQL-server-name\\instance-name,non-standard-port-number
4. Save and then run pdm_configure
5. Start SDM if it does not start yet

 

 

Additional Information

This has been addressed with the CA SDM 17.4 installer

Below are the CA SDM 17.4 install documentation links:

Install CA SDM 17.4

CA SDM Server Configuration Utility

Installing CA SDM 17.4 RU1

Installing CA SDM 17.4 RU2