INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

High availability for SSRS on SQL Cluster 2012?

High availability for SSRS on SQL Cluster 2012?

(OP)
Hi,

We are trying to determine how to provide SSRS for high availability since is not cluster aware. We have active/passive SQL Server 2012 cluster with Enterprise Edition where the other node is truly passive so only one active node is licensed. MS recommends scale-out deployment and if I understand well I will need additional servers with SQL Server (standard edition minimum on each) with SSRS installed and use shared database on cluster and use NLB - this is not an option for us.
Is it possible to use only existing SQL cluster nodes and create HA Scale-Out Deployment of SSRS? Are there any possible reason not to go with this? Do we need to license the passive node? I don't need NLB in this case, right?
I found this solution http://www.tfsconsulting.com.au/how-to-configure-h... but I am not sure where it will my report request go (on which SSRS) and do I need passive node licensed in the any case as SSRS will run on both nodes (only one SSRS server is handling requests)?

Just as clarification - we need high availability using current sql cluster and not load balancing capability.

Thanks.

RE: High availability for SSRS on SQL Cluster 2012?

HI There,

is the storage shared on independent?

I have encountered this type of issue in the past and what i have done is the following:

configure reports on node1 but use the server cluster name as the connection server, then browse to the reports database etc.
take a backup of the encryption key for use later.
verify the url works with the cluster server name (http://clustername/reports

If this is up and running then backup the reports databases and failover to node2. if its shared storage then the databases should all be on node2 aswell but you will need to reconfigure the reports within the SSRS confif manager on node2. use the same steps as node1, point to the cluster and also restore the encrytped key. this should add the second node to the scale out deployment. you see this in the bottom tab od the SSRS config manager.

verify the URL works.

If the URL works then fail back to node1. from now on it shouldn't matter which node the db's are on the SSRS should function.

Hope this helps

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close