APPInsight for SQL over agent

Question

Hi,

Ticket logged but not getting to far #00147897

All my apinsight for SQL over the solarwinds agent now have an error.

"Unable to establish SQL connection, check credentials. Keyword not supported: 'TransparentNetworkIPResolution'."

this is since upgrading my main polling engine to Windows Server 2016.

We are at the point where Devs have suggested upgrading the dotnet version on the client machines.. not the solarwinds boxes? But this is not possible there are multiple boxes with different applications different O/S' its a minefield.

They are using agent because they are in the DMZ or offsite so cant change to wmi. AppInsight over WMI seems to work from what I can tell.

Anyone any ideas serena ?

thanks

dodo123 · Answer

from what I can tell everything was working before the main polling engine became 2016, my additional polling engines were already on 2016.

But the issue is across multiple engines now.

mikeit83 · Answer

Yet Solarwinds is wanting to deprecate 2012 R2 on the next release

I had a tac case this weekend that the support guy was comparing .net versions-  to they must be on the lookout for something.

All of our servers are still 2012 with the exception of one APE that is now 2016.

disabledjeff · Answer

I got the same issue. I'm able to use component monitors for SQL parts, yet App Insight tells me the same thing.