The sql_check_db.exe utility can be used to check the status of database connection for Service Desk.
Service Desk Manager
All Supported Operating Systems
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".