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?
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?