The connection to any remote windows system does not work.
The database connection is working fine (connectivity and monitoring).
Recreating the windows connection does not fix the issue.
The user is a local user on the remote machine (it cannot belong to the local admin group).
By default only the local Administrators group has remote permissions to WMI. How to configure WMI "Remote Enable" permissions:
1. Add the user(s) in question to the “Performance Monitor Users” group;
2. Open “Computer Manager” | “Services and Applications” | rightclick on “WMI Control” | Properties | open “Security” tab. Select “Root” | “CIMV2” namespace and hit “Security” button. Add “Performance Monitor Users” group and enable the options : Enable Account and Remote Enable
3. Run dcomcnfg. At Component Services > Computers > My Computer, in the COM security tab of the Properties dialog click "Edit Limits" for both Access Permissions and Launch and Activation Permissions. Add Performance Monitor Users and allow remote access, remote launch, and remote activation
4. Select Windows Management Instrumentation under Component Services > Computers > My Computer > DCOM Config and give Local Launch, Remote Launch, Local Activation, and Remote Activation privileges to Performance Users Group.
Note: Using a restricted account may not return all data that Spotlight on Windows displays.