"Field 'Database Username' is invalid" error during DX UIM 23.4 installation with domain user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

During a clean installation of DX UIM 23.4, specifically at the database registration stage, the installer returns an error message when a domain user (e.g., DOMAIN\User) is entered. The error indicates the backslash character (\) is invalid for the "Database Username" field. This prevents customers with strict "no local user" policies from completing the installation.

Environment

- DX UIM 23.4 any version
- Microsoft SQL Server

Cause

The DX UIM installer GUI does not support the backslash (\) character in the database username field during initial setup. This field is designed to accept SQL Server-authenticated users, while domain-based Windows Authentication must be configured as a post-installation step.

Resolution

The recommended workflow is to perform the initial installation using SQL authentication and then transition to Windows Authentication.

1. Install with SQL Authentication:

   • Temporarily enable Mixed Mode authentication on the SQL Server.
   • Provide a SQL-authenticated user (such as sa or a temporary account with sysadmin privileges) in the installer GUI.
   • Complete the DX UIM 23.4 installation.

2. Transition to Windows Authentication:

   • Change the Nimsoft Robot Watcher service on the Primary Hub and OC servers to "Log on" as the desired domain user.
   • Configure the data_engine probe by adding Integrated Security=SSPI to the connection parameters: Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI
   • Restart the Nimsoft Robot Watcher service to verify connectivity.

Additional Information

SQL Authentication Requirements 
Switch Authentication Method