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"

[Kamble_Supriya]

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