Report page loading issue on WSFC with SQL Server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1238595%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-1238595%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%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%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EHaeKwon%2C%20HWANG%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1238595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EReporting%20Services%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,

HaeKwon, HWANG

0 Replies