How to check the status of the database connection for Service Desk?

Products

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

Issue/Introduction

The sql_check_db.exe utility can be used to check the status of database connection for Service Desk.

Environment

Service Desk Manager 
All Supported Operating Systems

Resolution

Run the following command to check status of db connection:

sql_check_db -t -s <Primary_Server> -n <dbnode>] [ -d<dbname>] [ -o <NX_MDB_OWNER> ] [ -U <dbuserid>] [ -p <password> ]

Where

t - Test connection only
s - Primary Server name
n - Database node (NX_DB_NODE)
d - Database name (NX_DB_STUFF)
o - Table Owner name (NX_MDB_OWNER)
U - Login userid (NX_DB_USERID)
p - Password

Note: You may review NX.ENV files for the values such as NX_DB_NODE.

The utility should return with the below results for a successful DB connection:

This utility would be useful for diagnosing problems such as the Service Desk services failing to start, with the popup error:

"Cannot connect to database".