After an upgrade, the configuration portion failed in SIM (Symantec Installation Manager). During the database configuration portion, the following message is displayed:
A critical error occurred:
Altiris.NS.Exceptions.DatabaseNotReadyException: Failed to construct DatabaseContext object. Connection to database failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Altiris.NS.Exceptions.DatabaseNotReadyException: SQL Catalog is not set in CoreSettings.config
CoreSetting.config was not updated properly, either the SQL Server or Catalog value name. Possibly due to insufficient rights to write the file.
As well you can configure the database information via SIM (starting with SIM 8.1 and later). Open SIM>Configure settings>Configure Database Settings and add the proper details.
Previous approach on earlier versions: You can run from the command line as Administrator (adding the proper details):
AeXConfig.exe /db dbserver:DatabaseServerName\Instance dbname:Symantec_CMDB dbusername: dbpassword : dbtimeout :1600
Run a reconfiguration again via SIM.
215640 "Upgrade or Repair fails with error: SQL Catalog is not set in CoreSettings.Config"