Problems migrating the Database to a new server

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Symptoms

The following error messages were produced in the iaoutput.log:

2014-12-19 14:51:25,264 WARN com.nimsoft.install.nimcommon.probe.ProbeController:waitForResponse:349 [Thread-64] - nametoip failed: (80) Session error, Unable to open a client session for 194.151.81.120:48000: Connection refused: connect?

and in the nimbus_manager.log after starting the Infrastructure Manager:?

Dec 22 10:08:23:141 [3516] Infrastructure Manager: sockConnect - gethostbyname ::1 failed 2?
Dec 22 10:08:23:141 [3516] Infrastructure Manager: nimSessionNew - _probeCheckin failed - communication error?
Dec 22 10:08:23:141 [3516] Infrastructure Manager: sockConnect - gethostbyname ::1 failed 2?
Dec 22 10:08:23:148 [3516] Infrastructure Manager: Warning - Communication error on request (gethubs)?

Solution

After investigating the database_engine.log file, a DB configuration issue was identified, as per the reported error messages being written in the database_engine.log:

Dec 22 11:05:29:756 [0364] de: [main] Open - 1 errors?
Dec 22 11:05:29:756 [0364] de: (1) Open [Microsoft OLE DB Provider for SQL Server] [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.?
Dec 22 11:05:29:756 [0364] de: COM Error [0x80004005] Unspecified error - [Microsoft OLE DB Provider for SQL Server] [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.?

First of all, check the data_engine.cfg file and confirm the right servername is specified.

Also, confirm the user account that it's being used for the install has the required access, and verify the type of authentication the SQL Server has configured. (In a previous case, the issue was resolved after uninstall and reinstalled it with a SQL Login instead of a windows account. Installation went without errors and everything was installed now, including all probes and services.)
?

Environment

Release:
Component: UIMDEG