Report page loading issue on WSFC with SQL Server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1245739%22%20slang%3D%22en-US%22%3EReport%20page%20loading%20issue%20on%20WSFC%20with%20SQL%20Server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245739%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20question%20the%20Analytics%20and%20Reporting%20loading%20issue%20on%20WSFC%20with%20SQL%20Server.%3CBR%20%2F%3EI%20added%20lists%20of%20all%20recommended%20ports%20rules%20and%20rules%20for%20SQL%20Server%2C%20SSAS%2C%20SSIS%2C%20and%20SSRS%20services%20to%20inbound%20on%20Windows%20firewall.%3CBR%20%2F%3EIf%20turn%20off%20Windows%20firewall%20for%20only%20Public%20network%20settings%2C%20the%20Analytics%20and%20Reporting%20page%20load%20normally.%20But%20it's%20not%20connect%20the%20Analytics%20and%20Reporting%20when%20turn%20on%20Windows%20firewall.%3CBR%20%2F%3EI%20think%20that%20the%20Public%20network%20is%20related%20the%20SQL%20IP%2C%20Cluster%20IP%2C%20DTC%20IP%20using%20Guest%20or%20public%20networks%20of%20Windows%20firewall.%3CBR%20%2F%3EWhat%20firewall%20rules%20are%20needed%20for%20guest%20or%20public%20networks%20of%20Windows%20Firewall%20on%20WSFC%20with%20SQL%20Server%3F%20How%20to%20resolve%20this%20issue%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1245739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EClustering%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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,

4 Replies

You can turn on some logging for the profile in use to determine what's blocked.

 

firewalllogging.jpg

 

 

 

I know the same logging settings of Windows Firewall.
I have set the dropped packets in the same setting a month ago, but no logs were recorded.
I wiil be try one more time.
I tried again logging for the Public Profile but there is only ALLOW logs, no BLOCK log.
What is another option?
Thanks.

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