topic Re: MSSQL extension is not working in Extensions

MSSQL extension is not working

seema — Fri, 16 May 2025 08:24:18 GMT

Hi team,

I configured the database connection for MSSQL and activategate is also installed. But getting the following error "Failed to assign monitoring configuration to ActiveGate. Reason: Fastcheck no response - datasource exited without providing status"

Re: MSSQL extension is not working

Supriya_K — Fri, 21 Mar 2025 19:43:33 GMT

Hi Seema,

You can start by checking if the firewall connectivity between the Active Gate and the MSSQL Server is established.

To verify connectivity, run the following command from the Active Gate server:
telnet MSSQL Server IP Port(1433)

Source: Active Gate Server
Destination: MSSQL Server
Port: Default is 1433 (Verify the actual port your database is running on and open it accordingly)

Firewall connectivity must be established between the MSSQL Server and the ActiveGate Server for the extension to execute queries. Ensure that the database user created for the Dynatrace extension has the required permissions to query the database and fetch data.

Re: MSSQL extension is not working

seema — Fri, 21 Mar 2025 20:08:32 GMT

Tested, it works fine.

Re: MSSQL extension is not working

AntonPineiro — Mon, 24 Mar 2025 12:04:34 GMT

Hi,

You can check ActiveGate logs extensions for more details, default is "/var/lib/dynatrace/remotepluginmodule"

Best regards

Re: MSSQL extension is not working

Rameshbabu — Thu, 15 May 2025 08:51:16 GMT

Hi Anton,

as per the logs, it saying that monitor not assigned to ActiveGate. then how can we find ActiveGate details.

I am also getting the same issue for one of the configurations. in my environment we have multiple ActiveGates are there.

Best Regards..

Re: MSSQL extension is not working

AntonPineiro — Thu, 15 May 2025 09:39:43 GMT

Hi,

You should check logs in every ActiveGate in the ActiveGate group where extension is configured.

You can do it using SSH/RDP to target ActiveGates or generating ActiveGate diagnostics for checking logs.

Best regards