UIM Upgrade fails with Login failed
Article ID: 195250
Updated On:
Products
Issue/Introduction
Running the UIM upgrade from one version to Another 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)
Environment
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.
Resolution
- On the IM go to the primary hub
- Select the data_engine probe
- Select the database tab
- Verify the database connection information are correct
-
Make sure the port is added with the server information as the format below:
Server\Named Instance,<port number>
or
Fully.Qualified.Domain.Name,<port number> - Run "test connection" and make sure the test results as below:
test connection DONE - result:
Connected: yes
Ping: yes - proceed with the upgrade.
Feedback
