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