topic Re: Microsoft SQL Extensions for Dynatrace Managed in Extensions

Microsoft SQL Extensions for Dynatrace Managed

Haziq — Wed, 12 Jul 2023 06:56:00 GMT

Hi currently running a managed Dynatrace environment. I am trying to monitor a Microsoft SQL server using ActiveGate Extension and have successfully installed AG and the extension.

Based on documentation, under connection parameters, https://www.dynatrace.com/support/help/shortlink/ms-sql#connection-parameter-details, it says to provide a port number "on which SQL Server is ready to accept connections from ActiveGate".

My questions would be
1) do I need to set an outbound connection from ActiveGate to the SQL server or is it the other way round?

2) Is there a recommended port that I should be using?

3) When trying to set the configurations, the option to input port number is indicated as "optional". What would be the best practice here?

Thanks.

Re: Microsoft SQL Extensions for Dynatrace Managed

Mike_L — Wed, 12 Jul 2023 07:00:27 GMT

Hi,

That would be the port on which the database is listening for queries. By default for SQL server it is 1433, but you can change it on that screen if your server is listening on another port.

Re: Microsoft SQL Extensions for Dynatrace Managed

Haziq — Wed, 12 Jul 2023 09:56:33 GMT

I tried using 1433 but it still is giving me the error. Any other configurations should I check?

Re: Microsoft SQL Extensions for Dynatrace Managed

Mike_L — Wed, 12 Jul 2023 12:03:42 GMT

What error do you see if you click on error (that brings you to the logs)? Can you telnet from the ActiveGate to the SQL server that you're trying to connect to? Maybe there is a firewall blocking the connection.

Re: Microsoft SQL Extensions for Dynatrace Managed

Kenny_Gillette — Wed, 12 Jul 2023 12:06:52 GMT

Hi,

1) do I need to set an outbound connection from ActiveGate to the SQL server or is it the other way round?

are firewall rules open from AG to SQL server. That is my guess.

Re: Microsoft SQL Extensions for Dynatrace Managed

Haziq — Thu, 13 Jul 2023 03:27:15 GMT

I'm unable to see the logs for that as the environment currently does not have log monitoring v2 enabled.

Re: Microsoft SQL Extensions for Dynatrace Managed

Mike_L — Thu, 13 Jul 2023 10:55:29 GMT

You can find the logs directly on the ActiveGate as well. It might be easier to open a support case though. That way our support can get the log files and let you know how to resolve it.

Re: Microsoft SQL Extensions for Dynatrace Managed

virdsing — Fri, 29 Mar 2024 14:33:57 GMT

Is it uni-directional connection?

Re: Microsoft SQL Extensions for Dynatrace Managed

vagiz_duseev — Fri, 29 Mar 2024 23:21:32 GMT

Yes, it's always the ActiveGate connecting to the SQL Server instance and never the other way around.

Re: Microsoft SQL Extensions for Dynatrace Managed

gsaharan — Mon, 10 Nov 2025 17:24:48 GMT

Hi,

I am trying to integrate the same MySQL extension in my managed environment, but I am unable to capture or identify the expensive SQL statements. Could you please help me with this?

Re: Microsoft SQL Extensions for Dynatrace Managed

Julius_Loman — Mon, 10 Nov 2025 19:44:21 GMT

@gsaharan have you checked the prerequisites for the Microsoft SQL extension for top queries?

Re: Microsoft SQL Extensions for Dynatrace Managed

gsaharan — Tue, 11 Nov 2025 04:36:26 GMT

Yes i did