I've got a 2-node failover AG setup. I want to add a 3rd node to be used as a reporting server. That could be read-only, but has to be available all the time. For reasons beyond my control, I can't use replication. The database has no primary keys indexes (3rd-party software design). So, it all has to be done via AG.
I'm means that I need to use enterprise edition on my failover cluster, but can the SSRS server be standard edition or does it also have to be enterprise?
June 17, 2020 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
You will need a third-node in your cluster - licensed with Enterprise Edition. I would not put SSRS on this server - but it can be...
This third-node does not have to be sized the same though. You can reduce the number of CPUs and the amount of memory - since it will only be utilized as a read-only secondary with no fail over.
I would recommend installing SSRS on a separate server - with both the database engine and the reporting services. For that - you can utilize standard edition, but be aware that it will limit some of the functionality available. For example, you will not be able to setup data-derived subscriptions or scale-out the solution.
There are some items for consideration - since the third-node will only be for read-only usage you would set the node weight to 0 and remove the node as an available node for the FCI cluster.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2020 at 12:09 am
What vesion of SQL Server is involved? Is it 2012, 2014, 2016, etc. Also, why are you saying you need Enterprise Edition on your failover cluster? You can set up a separate SSRS node and have the reports that are deployed there hit the AG Listener name and if you set up read only routing, those reporting queries can go to the 3rd node you are wanting to add to your AG. For that matter, you could just use your current secondary as a read only replica via read only routing.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply