A couple times now, I've been bit by the fact that AppInsight for SQL doesn't work with MS SQL clusters or with Windows Domain credentials.
In my case, I've modified the default template to prefer agentless communication.
Perhaps this should be the default until the monitor supports agents better?