NetWorker: Upgrade of NMC to 19.10+ on Windows Server Fails

• Installation fails and rolls back when Installing NetWorker Management Console (NMC) package is selected for install.
  • The ..\EMC NetWorker\Management\GST\logs\gstdbinit.log reports:

    waiting for server to start.... done
    server started
    107567:gstdbinit: Unable to allocate ODBC connection
    107571:gstdbinit: ODBC Error:IM003:160:Specified driver could not be loaded due to system error  126: The specified module could not be found. (PostgreSQL Unicode(x64), C:\Program Files\EMC NetWorker\Management\GST\postgres_latest\odbc\psqlodbc35w.dll).
    waiting for server to shut down.... done
    server stopped

• NMC package installed successfully, but the NMC server process (gstd) fails to start. Errors logged in the ..\EMC NetWorker\GST\logs\gstd.raw indicate that it could not load the Postgres module.

  YYYY-MM-DDTHH:mm:SS 1 5 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR notice MM/DD/YY HH:mm:SS gstd-D1    IM003: Specified driver could not be loaded due to system error 126: The specified module could not be found. (PostgreSQL ANSI(x64), C:\Program Files\EMC NetWorker\Management\GST\postgres_latest\odbc\psqlodbc30a.dll).
  YYYY-MM-DDTHH:mm:SS 1 5 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR notice MM/DD/YY HH:mm:SS gstd-D1 Internal error: could not get database handle.
  YYYY-MM-DDTHH:mm:SS 1 5 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR notice MM/DD/YY HH:mm:SS gstd-D0 Internal error: could not get database handle.
  YYYY-MM-DDTHH:mm:SS 1 5 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR notice MM/DD/YY HH:mm:SS gstd-D0 Please also see the log files in 'pg_log' directory inside the product's database directory for the database server's output messages
  YYYY-MM-DDTHH:mm:SS 1 5 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR notice MM/DD/YY HH:mm:SS gstd-D0 Internal error: could not release database handle.
  YYYY-MM-DDTHH:mm:SS 2 0 0 5560 8512 0 NMC_SERVER_HOSTNAME gstd NSR warning library error 22 os error 0

The Windows server is missing the Microsoft Visual C++ 2015 - 2022 package. The package is not listed under:

Control Panel -> Programs -> Programs and Features

The NetWorker 19.13+ installer includes the following warning:

1. Install X64 Microsoft Visual C++ 2015 - 2022 Redistributable on the Windows host. The package can be obtained from: 

https://learn.microsoft.com/cpp/windows/latest-supported-vc-redist?view=msvc-170 

Once installed, the package should be listed under Control Panel -> Programs -> Programs and Features:

2. Install NetWorker and NMC packages.

3. Validate that the NMC server is accessible from the NMC launcher.

NetWorker: How to Recover the NMC database?
NMC database backup fails after update to NetWorker 19.11
NetWorker: NMC Service and Accessibility Issues (General Troubleshooting Guide