Pdm_configure Warning "The database server node is invalid" during Database Configuration step

Products

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

Issue/Introduction

Customer is running pdm_configure when trying to perform the post installation steps manually.

After populating all fields in the MS SQL Database Configuration screen, there is a warning generated:

• The database server node is invalid. Correct it and continue.

The Database Server field is populated with the server name.

Investigating the usp_servers, al_cdb_configurationparameters, and al_cdb_componentinstallstate found references to the server listed as <SERVER_NAME>

nx.env also uses <SERVER_NAME> to reference the database server.

Testing sqlcmd -S <hostname,port> -U mdbadmin -P <Password> results in a successful connection. 

The database client software is confirmed to exist on the server. 

configuration.properties has resources.created=0 per the documentation. 

Environment

All SQL Databases

All Oracle Databases

All Versions of Service Desk Manager

Cause

When database was installed, it was installed in a way that requires the instance name to be provided instead of just the server name. 

Resolution

Engage the database team to check if the instance name is required.

If so, provide the server name as:

<SERVERNAME>\<INSTANCENAME>

Additional Information

Also note, if you are configuring an MDB on a remote SQL Server machine, you must first install the SQL client on the Service Desk Manager Application Server.