October 18, 2013 at 10:08 am
I have a clustered environment with 3 nodes and 2 instances on it with 1 node always as a passive one.
Customer wants to use one of these instances to configure SSRS now.
How would I install SSRS in this scenario. Customer doesn't want to procure a new license though.
October 18, 2013 at 12:53 pm
Hi Benki, 😀
I think SSRS is not cluster aware.
Check this post :
http://technet.microsoft.com/en-us/library/bb630402.aspx
Hope it helps.
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
October 18, 2013 at 12:55 pm
Hi Jony,
I am not bothered if its cluster aware or not. All I need to do is make sure the report server DB sits on the clustered instance 😛
October 18, 2013 at 1:06 pm
October 18, 2013 at 2:03 pm
The clustered SQL setup is already there.
I just need to put a SSRS and put the report server database in clustered instance
October 23, 2013 at 8:09 am
Friends,
Can I please get some help on this?
I found an article which was talking almost similar to my requirement. Can this work out?
October 23, 2013 at 9:40 am
One potential solution is to have your SSRS databases installed on your clustered SQL Instance.
Then on the physical node install the SSRS Server, each configured to use the same shared databases but there own dedicated storage (non shared storage).
Create a scale out deployment which encompases all SSRS Servers (the physical nodes), you will then need some sort of load balancer to direct trafic from a virtual url to one of the individual report servers.
We have done this in the past as a temporary measure, but now we have a SSRS farm of servers in a scaled out deployment, all accessed via a load balancer and virtual URL the databases supporting the SSRS servers reside in a clusterd SQL Server Instance.
MCITP SQL 2005, MCSA SQL 2012
October 23, 2013 at 10:12 am
without scale-out deployment ,how does this work.
I mean, Can I install SSRS on just active node and deploy the report server database on the clustered instance?
Going by common sense, I dont think I can install SSRS on both Active and passive nodes and make them point to common shared report server database hosted on a clustered instance.
October 23, 2013 at 10:27 am
Remember the hosts are neither active or passive as both are up and connectable regardless of whether or not they are the active node for the clustered SQL install.
Think of it this way you have two nodes both windows servers dbasql1 and dbasql2. The virtual host which is the SQL clustered name is dbaSQL.
You have a local disk on each server which is not shared storage, say Drive x.
It's always possible to browse the network to dbasql1\x$ and dbasql2\x$ Regardless of which is the active node for the sqlcluster ( dbaSQL).
Providing both SSRS installs are on the x drive on each server the SSRS engines can be up without worrying about active / passive nodes.
With the SSRS databases stored on the clustered instance dbaSQL both SSRS engines can connect to the shared databases.
MCITP SQL 2005, MCSA SQL 2012
October 23, 2013 at 11:23 am
Thanks.
But what would happen if the scenario is like this:
There are 2 nodes NodeA and NodeB and there is one instance called Inst1
NodeA is active and NodeB is passive.
I install SSRS only on NodeA and the report server database sits on Inst1 obviously.
How would SSRS react?
October 23, 2013 at 11:27 am
Proving your SSRS install is not on shared storage and it is configured correctly with its database connection string to the clustered database it will not make any difference to SSRS what node is active.
Obviously during a failover between nodes the databases would be temporarily unavailable but once the SQL services are back online all would resume as normal.
MCITP SQL 2005, MCSA SQL 2012
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply