Try to connect from Orion box using wbemtest.exe tool to one of the SQL servers. Choose root\cimv2 namespace and domain credentials you are using for WMI monitoring in APM. If connection from wbemtest doesn't work, there is some environmental issue. In this case try WMI Troubleshooting Guide. If the connection from wbemtest works, open a support ticket.
We have seen this issue when DNS server was configured incorrectly so Windows thought that remote node DNS names resolves to localhost IP.
In that case wbemtest also wouldn't able to connect. So I agree with tomb - wbemtest should be the first thing to try.
If you do open on support ticket, could you:
--Reference this thread to Support.
--Post back here with a case number.
--Post any solutions you get from Support.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.