# Failed to assign monitoring in MSSQL Extension **URL:** \ **Category:** Extensions\ **Tags:** sql, activegate, mssql, extensions\ **Created:** [March 30, 2023, 10:29am UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088 "2023-03-30T10:29:41Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Starhut](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@Starhut](https://community.dynatrace.com/u/Starhut)\ **Post date:** [March 30, 2023, 10:29am UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/1 "2023-03-30T10:29:41Z")
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? [Error log.pdf](https://community.dynatrace.com/uploads/short-url/fvjUoS0t5vtZpDrjoclpWJeetza.pdf) (17.2 KB) [active gate.pdf](https://community.dynatrace.com/uploads/short-url/c2EwWzBHR9YFPF6rJcHljZ9QrWq.pdf) (22.8 KB) ---
**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\ **Post date:** [March 30, 2023, 6:05pm UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/2 "2023-03-30T18:05:35Z")
Hi, Have you assign a [group](https://www.dynatrace.com/support/help/shortlink/activegate-group) to ActiveGate? Best regards ---
**Author:** ![radek\_jasinski](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/radek_jasinski/32/10432_2.png) [@radek\_jasinski](https://community.dynatrace.com/u/radek_jasinski)\ **Post date:** [March 30, 2023, 7:26pm UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/3 "2023-03-30T19:26:52Z")
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 ![Screenshot 2023-03-30 at 21.14.59.png](https://global.discourse-cdn.com/dynatrace/original/3X/3/4/34e51da5388a72c5a635ae062ca4291b890b715e.png) Please follow the documentation: [Route OneAgent traffic to Dynatrace, monitor cloud environments and remote technologies using extensions — Dynatrace Docs](https://www.dynatrace.com/support/help/shortlink/activegate-routing-monitoring#monitor) Remember that it only works on the Environment ActiveGate. Radek ---
**Author:** ![Starhut](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@Starhut](https://community.dynatrace.com/u/Starhut)\ **Post date:** [March 31, 2023, 3:32am UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/4 "2023-03-31T03:32:40Z")
Group is assigned by default. ---
**Author:** ![Starhut](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@Starhut](https://community.dynatrace.com/u/Starhut)\ **Post date:** [March 31, 2023, 3:36am UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/5 "2023-03-31T03:36:30Z")
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. > **[Configuration properties and parameters of ActiveGate](https://docs.dynatrace.com/docs/ingest-from/dynatrace-activegate/configuration/configure-activegate)** > > Learn which ActiveGate properties you can configure based on your needs and requirements. After that, error gone and connection was up for the extension. ---
**Author:** ![vicolmenares](https://avatars.discourse-cdn.com/v4/letter/v/90ced4/32.png) [@vicolmenares](https://community.dynatrace.com/u/vicolmenares)\ **Post date:** [May 30, 2024, 3:40pm UTC](https://community.dynatrace.com/t/failed-to-assign-monitoring-in-mssql-extension/39088/6 "2024-05-30T15:40:55Z")
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? ![DynatraceSQL_Exten_error.jpg](https://global.discourse-cdn.com/dynatrace/original/2X/d/d79c03cca826118200f6ca70c51be8f8b1cba0aa.jpeg)