March 13, 2012 at 9:59 am
Hi,
I'm installing SQL Server 2008 R2 Reporting services.
Is Load balancing is possible for SSRS?
What technology we need to use to provide High availability for SSRS?
Thanks
March 13, 2012 at 10:10 am
if you have enterprise edition you can do a scale out deployment where you have multiple hosts acting as SSRS front ends which will give load balancing and HA if a node dies the other nodes carry on.
last time I checked SSRS wasnt cluster aware so needed to be configured on each node in a cluster if you used SSRS in a clustered environment
March 13, 2012 at 12:20 pm
SSRS is not cluster aware under MSCS, although you could look at Veritas Cluster Server to achieve high availability here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2012 at 12:35 pm
Link to walkthru on an SSRS scale out
The only thing I would add is make sure you have console access to the report server when configuring MS NLB as you may lose connectivity via RDP.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply