MSSQL extension is not working

[seema]

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"

[Supriya_K]

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.

[seema]

Tested, it works fine.

[AntonPineiro · Accepted solution]

Hi,

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

Best regards

[Rameshbabu]

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..

[AntonPineiro]

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