cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsmudge35
Frequent Visitor

PBI Report server & F5 Load Balancer

Hi, has anyone on this forum successfully load balanced 2 PBI Reporting servers using through an F5 Load Balancer?  We are using https, but not through the F5.  The SSL certificates have been installed to each PBI Report Server.  I am keen to understand; 

 

- How you configured your F5 Health Monitors. 

- Changes made to the rsreportserver.CONFIG file.

 

ANy help much appreciated. 

 

Thanks

Darren  

 

4 REPLIES 4
d_gosbell
Super User
Super User

We've got PBIRS working on a 2 node load balanced cluster behind an F5. However I'm not sure what specific rules our infrastructure team setup on the F5, so I'm assuming it was some sort of default ruleset. 

 

For the PBIRS configuration we just carefully followed the instructions here https://docs.microsoft.com/en-us/sql/reporting-services/report-server/configure-a-report-server-on-a...  

We are experienceing intermittent errors that could point to an error in the F5 configuration. We use Cookie persistence:

Rastenberger_0-1642161635110.png

Do you have the same setup or different "stickiness"?

 

Hi, we have had this working successfully through the F5 with config of; 

Load Balancing Method = Least Connections

PersistanceType = Source Address Affinity 

Thks

Thanks for your response, after spending some time today with Networks team showing me the F5 Config.  http F5 Monitors work fine, its only https Health Monitors that are failing.  This is because the F5 can only use an IP address for the PBI Report server.  So it connects like this https://10.1.x.x/reports  and fails with a 404 error.  If I try and access this url through Chrome then I get the SSL cert error.  I believe this is because the IP is not listed in the Subject Alternative Names section in the SSL certificate and also  no url reservation in the rsreportserver.config file.  

 

Therefore it seems the only way to fix this this, is to remove the https config in Report Manager, remove the SSL certificates from PBI RS server and obtain new ssl certs with the PBI RS IP address listed in the SAN section. Import again and do the PBI RS https config again. 

 

Would be interested to know if this is how you have your certs configured. 

 

Thanks

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!