During a reconfiguration SIM error: Connection to database failed.
Last Updated May 06, 2019
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.
Open the coreSettings.config file (under C:\ProgramData\Symantec\SMP\Settings)
Check if the "value" parameter is missing the SQL Server name or the name of the database. If it is, then add it and save 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 /dbdbserver:DatabaseServerName\Instance dbname:Symantec_CMDB dbusername: dbpassword : dbtimeout :1600
Run a reconfiguration again via SIM.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe