UIM Upgrade from 8.5.1 to 9.0.2 fails with Login failed for user 'sa'

book

Article ID: 195250

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

Running the UIM upgrade from 8.5.1 to 9.0.2 the installer requests the UIM administrator and password.

These are supplied but the installer then reports Login failed for 'sa'

The uimserver_ia_install.log also shows the error:

2020-07-01 09:06:24,428 ERROR provider.NimDBProviderBase:createConnection:167 [SwingWorker-pool-1-thread-1]  - Login failed for user 'sa'. ClientConnectionId:a7b981c9-0a14-448f-8900-183ece62ea3e
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:a7b981c9-0a14-448f-8900-183ece62ea3e
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)

Does the MS SQL user/password need to be supplied here instead ?

 

Cause

The correct user/password at this stage is the UIM Administrator user and password however for an upgrade the installer attempts to check some database configurations using existing credentials as seen in the data_engine probe.

In this case the uimserver_ia_installer also reported the following earlier in the log:

2020-07-01 09:06:24,233 DEBUG individual.SqlserverDBProvider:postProcessServerName:124 [SwingWorker-pool-1-thread-1]  - postProcessServerName: 'port' is empty. Setting to default value: 1433

MS SQL was using a dynamic port and not the default 1433. The dynamic port had not been specified in the data_engine configuration so the installer defaulted to using 1433 and failed.

Environment

Release : 8.51
Component : UIM - INSTALL

Resolution

Updated the data_engine Data Source to also include the port number e.g.

Server\Named Instance,<port number>

or

Fully.Qualified.Domain.Name,<port number> 

Confirm that the data_engine still connects and operates correctly then proceed with the upgrade.