I’ve been working on a BigFix migration and have hit a snag. I’ve been following the directions from https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Server%20Migration per HCL support.
The database was a remote database and now it will be a local database on the new server (which will also be the new main server). I copied the databases over via SQL backup (full) and restore, which appeared to successful.
Documentation had me copy several files from the old server to the new, then run the server setup (after the databases were copied). The setup wizard never asked for any authentication info for the (now) local databases.
After install, BigFix Diags showed several things wrong.
Client Register Plugin, Post Results Plugin, BESGatherMirror Plugin, BESGatherMirrorNew Plugin, BESMirrorRequst Plugin all say “The HTTP request failed with error Unexpected HTTP response: 503 Service Unavailable”.
Checked ODBC and it was pointing to the old remote SQL server. Changed all the connections to “(local)”, set the sa password and tested connections; all pass.
Restarted server, still no luck.
FillDB.log has multiple “Tue, 18 Feb 2020 11:30:53 -0800 – 3124 – Unexpected exception: Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘’. (28000: 18,456)” errors. This makes me think the software is still not connecting to the database.