We installed DPA 2024.4 which supports using a gMSA Account for monitoring. The monitoring is working perfectly, as are Alerts that do not use a sql query to determine the Alert condition/status.
Any alert on any Instance that needs to execute a database query is failing with this error: "A connection to the monitored database [DB - UTIL - UTILDBL07] could not be established [cause=org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: "User" (or "UserName") and "Password" connection properties must be specified for NTLM authentication.]"
In previous DPA versions when we used a regular AD Account + password we never had to configure the JDBC Connection separately for these Alerts, they just worked using the configured Monitoring account. The gMSA Account/Login has the sysadmin role so it is not a permissions issue.
Further, if I try to configure the JDBC Connection properties in the Instance Connection dialog, I cannot click Next because it requires a gMSA password value (which there is none because of the nature of a gMSA account).
Any ideas on how to fix this? (for now we have switched back to using a regular AD Account + password instead of a gMSA and everything works fine)
