Monitoring Azure SQL Managed Instances – Forum – Server & Application Monitor (SAM)

Hi,

I’m attempting to use a SQL Server User Experience monitor against an Azure SQL Managed Instance. I’ve added the managed instance as an external node, with a dynamic IP but it seems when i create the template, it always tries to run the query against the Ip not the dns name, which i believe is why it then fails?

e.g i get the following error 

Sql Server returned an error. Cannot open server “192.168.x.x” requested by the login. The login failed.

Has anyone had any success with this. Is there a better way to run SQL queries using SAM, against a managed instance

Read more here: Source link