We currently use the AppInsight for SQL monitor as well as the SQL Server 2005-2008 monitor on a few. I have set the "credential type" to "Windows credential" on all AppInsight templates. It appears the SQL Server 2005-2008 monitor template doesn't have that configuration option. While the monitors are working and logging in with Windows credentials, they are both still attempting to log in with SQL credentials as well. This is filling up the error logs on all instances. I submitted a problem ticket and this is the response I received:
" The ability to use an NTLM credential only is not currently available. If you would like, I can submit a feature request to get this functionality added"
I have searched THWACK and have only found a few posts related to this issue. A few of which were left unanswered. I find this kind of strange since the AppInsight templates provide an option to select the type of credential you want to use. I also would find it odd that this would be considered "normal" and expected behavior to generate over 30 errors/hour/instance since every other DBA shop I'm aware of logs failed authentication attempts. This would also mean that the "option" to select the authentication method is nothing more than an ornament that actually serves no purpose. This doesn't seem to be something terribly difficult to implement since all you need to identify an Windows credential is the "\" backslash.
Is there anyone else with this issue? Am I missing something?