I want to monitor with Foglight SQL Server with PI.
Which port i should open from the FGLAM server to my SQL Server? I want to monitor the SQL Server and also the OS (Windows server 2012)Can you please advise?
please look at this document. You will find a architecture overiew where the ports are listed.
Also this overview should be helpful - it is from this solution:
I hope that helps.
best is to use WinRM and then you need to open either 5985 (http) or 5986 (https) to the monitored server. Here the link to the WinRM setup.
If you want to use a domain user to do the collection, you should configure https / negotiate authentication, if you use a local user on the machine itself, you need to configure http / basic authentication.
Does that answer your question?
I'm following on this thread with some additional information.
There are two types of OS connection options to monitor a Windows operating system from the Foglight Agent Manager (FglAM).
Our recommendation is to use WinRM in Foglight environments instead of WMI because it is a secure, remote connection that is made over a single port, and does not encounter issues often associated with DCOM and RPC connections. As well, internally testing has found that a single FglAM can handle up to 75 agents using WMI.
If you are monitoring more than 75 agents running on a Windows System (FglAM), the monitored hosts should be configured to use WinRM.