WindowsAgents not created after validating connectivity and selecting to save changes for some SQL Server instances.
The following setting can be seen in the logs of the affected SQL Server agents.
createICAgentAuto=0
RESOLUTION: Run the attached script (updateASP_for_SQLServer_createICAgentAuto.groovy) from the script console to set createICAgentAuto=1 for allof the SQL Server agent.
configService = server.get("ConfigService");
agentService = server.get("AgentService");
results = new StringBuffer();
def modifyAgentPropertiesPrimary(agent) {
def primary = configService.getAgentInstancePrimaryAsp("DB_SQL_Server", "DB_SQL_Server", agent.getId());
//Only change false item
if (!primary.getBoolean("createICAgentAuto")) {
primary.setValueByString("createICAgentAuto", "true");
configService.saveConfig(primary);
results.append("Agent '" + agent.name + "' ASP has been changed; \n");
}
}
def agents = agentService.findByAdapterAndType("FglAM", "DB_SQL_Server");
for (agent in agents) {
modifyAgentPropertiesPrimary(agent);
}
return results.toString();