SQL Extension monitoring - The login is from an untrusted domain and cannot be used with Integrated authentication.

[Vidhyasagar]

Hello,

I am trying to onboard SQL Always On clusters using extension in Dynatrace and I am using AD credentials authentication.

Once configuration when I enable check, it gives error " The login is from an untrusted domain and cannot be used with Integrated authentication." which is expected lines.

As per the documentation of Dynatrace, they are asking to import server certificate to the keystore.  https://docs.dynatrace.com/docs/shortlink/microsoft-sql-monitoring#ssl

Please someone help on which certificate to be imported and how to pull the cert from the SQL cluster server.

[Mike_L]

There are many, many reasons why this error appears. It can be an incorrect password or different AD environments or a locked out user and several others. There are some good tips here: https://stackoverflow.com/questions/18603696/trouble-connecting-to-sql-server-login-failed-the-login...

[sivart_89]

We've personally seen that same error due to an incorrect password being used