SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.

AP 0 Reputation points
2024-05-29T23:10:13.39+00:00

I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed in order. As of right now only node 3 will work behind the NLB VIP. We are using Citrix netscaler/adm. Anyone else run into this? It's driving me mad. Please help :D

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,069 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2024-05-30T06:23:46.0733333+00:00

    Hi @AP,

    Please follow the steps in the official documentation to configure the SSRS scale out in case you miss something.

    Configure a Native mode report server scale-out deployment

    Is there any error message about node1 and node2?

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.