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


Article ID: 195250


Updated On:


NIMSOFT PROBES DX Infrastructure Management


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 ?



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.


Release : 8.51
Component : UIM - INSTALL


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

Server\Named Instance,<port number>


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

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