The Change Auditor Agent v7.5, 7.6, 7.6.1 will not start after successful installation
If the SQL Server 2022 Local DB doesn't get installed, the Change Auditor Agent doesn't start.
Below mentioned messages will be displayed in the Agent logs.
ID: 9019
Time: 1/22/25 18:46:08.339
Level: INFO
Thread: 10084
Logger: TorzagLib.Agent.CAgentDatabaseAccess
File: c:\ca_buildagent1\_work\66\s\component\torzaglib\agent\agentdatabaseaccess.cpp
Function: TorzagLib::Agent::CAgentDatabaseAccess::InstallSqlLocalDB
Line: 264
Message: No SqlLocalDB 16.0 registry key found, Installing SqlLocalDB 2022, version 16.0.
2025-01-22 18:46:08.690 [10084][ERROR][TorzagLib::Agent::CAgentDatabaseAccess::InstallSqlLocalDB(277)] WARNING: A reboot is pending. Please restart your system, agent will exit.
2025-01-22 18:46:08.692 [10084][WARN][TrogdorLib::Common::CTrogdorService::StartImpl(187)] Error initializing sub-system {Agent Database Access (2)}.
2025-01-22 18:46:08.694 [10084][ERROR][CMonitorService::OnStartFailed(506)] Failed to initialize some threads and sub-systems.
If SQL server Local DB 2022 and the required MSVC++ redistributable (2015-2022) are not installed on agent host, the CA agent will install them when started. So, it is suggest to restart the server a few times at different times (there is no predefined number).
