topic Re: Failed to assign monitoring in MSSQL Extension in Extensions

Failed to assign monitoring in MSSQL Extension

Starhut — Thu, 05 Jun 2025 13:45:27 GMT

HI, this is log given when I have configured a connection for MSSQL extension configuration.

Failed to assign monitoring configuration to ActiveGate. Reason: The monitoring configuration requires ActiveGate version 1.242.0 or later that supports data source sqlServer and belongs to group "default"

It doesn't make sense to me as the active gate version in our environment is way higher than the required version 1.242.

Has anyone encounter this before?

Re: Failed to assign monitoring in MSSQL Extension

AntonPineiro — Thu, 30 Mar 2023 18:05:35 GMT

Hi,

Have you assign a group to ActiveGate?

Best regards

Re: Failed to assign monitoring in MSSQL Extension

radek_jasinski — Thu, 30 Mar 2023 19:26:52 GMT

Hi Starhut,

I see that you are missing enabling the appropriate modules on ActiveGate, which are used to run extensions.

You have only enabled modules for:

Kubernetes
OneAgent routing
Rest API

You need two modules more:

Extensions 1.0
Extensions 2.0

Please follow the documentation: https://www.dynatrace.com/support/help/shortlink/activegate-routing-monitoring#monitor

Remember that it only works on the Environment ActiveGate.

Radek

Re: Failed to assign monitoring in MSSQL Extension

Starhut — Fri, 31 Mar 2023 03:32:40 GMT

Group is assigned by default.

Re: Failed to assign monitoring in MSSQL Extension

Starhut — Fri, 31 Mar 2023 03:36:30 GMT

Update of status:

After reminded by Radek, I went through to check the extension of module and found that required extension module was missing in EAG. A correction on Radek, he was looking at the first activegate (containerized AG), instead it should be second active gate (EAG). Nevertheless, module was missing and I have added it back through custom.properties.

https://www.dynatrace.com/support/help/shortlink/sgw-configure#extn1_mod

After that, error gone and connection was up for the extension.

Re: Failed to assign monitoring in MSSQL Extension

vicolmenares — Thu, 30 May 2024 15:40:55 GMT

Hi Radek, I have already configured these extensions and I tried to configure "Activate extension Microsoft SQL Server 2.3.0" But I got this error, could you please assist me with this issue?