SQL APM Template Issue

dl33ta

Noticing the following error pop up on our SQL servers that are being monitored by APM (v10):

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

In this case it is trying to use SQL service credentials instead of integrated security as per what we have set in the APM template.  Anyway to stop this behaviour?

jiri.tomek

Hello,
what monitor do you use? SQL User Experience monitor? You can select what kind of authentication to use first - windows or SQL. APM then tries selected method first and if it fails it tries the other. If you don't have "Use Windows Authentication first, then SQL authentication:" checkbox selected, APM tries SQL credentials first and it generates that log message. Try to check that checkbox to see if it helps.