Remote Control Server Installer Task Failed with Exit Code 31 (MSSQL Configuration)

Usage and Config
1

Hello,

I am trying to run the Remote Control Server Installer Task on Windows using MSSQL as the database backend, but the task fails with “Exit Code 31”.

Here is a summary of the action:

  • Database: MSSQL (local)
  • SQL Authentication: User sa
  • MSSQL Server Address: 127.0.0.1
  • Port: 1433
  • JDBC Driver: C:\JDBC\mssql-jdbc-12.10.1.jre8.jar
  • Database create directory: C:\TRCDB
  • Password is passed via -DMSSQL_PASSWORD parameter.

The log shows that the installer runs until this step:
waithidden __Download\trc_server_setup.exe -DMSSQL_PASSWORD=“Linux123!”
Failed continue if {exit code of action = 0 or exit code of action = 1}

After that, the task stops and reports Status: Failed with Exit Code 31.

I have verified that:

  • SQL Server service is running.
  • TCP/IP is enabled in SQL Server Configuration Manager.
  • The port 1433 is open.
  • The sa account is enabled and the password works in SQL Server Management Studio.

Question:
What does Exit Code 31 mean in the context of the TRC Server installer? Are there any additional logs or steps I should check to diagnose why the installer cannot complete the MSSQL configuration?

2

In the context of the BigFix TRC (Tivoli Remote Control) Server installer, Exit Code 31 typically means:

The host name was not obtained.

This error suggests that during the installation process, the installer was unable to retrieve the host name of the machine. This can happen due to DNS resolution issues or misconfigured network settings.

How to troubleshoot Exit Code 31:

Here are a few steps you can take:

  1. Verify Hostname Resolution:
  • Run nslookup <your-hostname> from the command line to check if the hostname resolves correctly.
  • Ensure that the hostname is properly set in your system and is reachable.
  1. Check Network Configuration:
  • Make sure your system has a valid IP configuration.
  • Confirm that DNS servers are correctly configured.
  1. Review Installer Logs:
  • Look into the installation logs for more detailed error messages. These logs can often be found in the installation directory or a temporary folder specified during setup.
  1. Try Manual Hostname Setting: