Mar 22 2020 10:29 PM
Hello,
I have a question the Analytics and Reporting loading issue on WSFC with SQL Server.
I added lists of all recommended ports rules and rules for SQL Server, SSAS, SSIS, and SSRS services to inbound on Windows firewall.
If turn off Windows firewall for only Public network settings, the Analytics and Reporting page load normally. But it's not connect the Analytics and Reporting when turn on Windows firewall.
I think that the Public network is related the SQL IP, Cluster IP, DTC IP using Guest or public networks of Windows firewall.
What firewall rules are needed for guest or public networks of Windows Firewall on WSFC with SQL Server? How to resolve this issue?
Thanks,
Mar 23 2020 06:34 AM
You can turn on some logging for the profile in use to determine what's blocked.
Mar 24 2020 12:18 AM
Mar 24 2020 07:10 PM
Mar 24 2020 07:14 PM
Not sure what is meant but you can also try wireshark or message analyzer.
https://docs.microsoft.com/en-us/message-analyzer/microsoft-message-analyzer-operating-guide