Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Install SSRS on some standalone server and create or point SSRS DB’s on to Active node Expand / Collapse
Author
Message
Posted Friday, April 05, 2013 4:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:30 AM
Points: 162, Visits: 728
Hi,



I got an request to install SSRS.

We got a cluster N1 [Active node and Passive Node].

Now they request to install SSRS on some standalone server and create or point SSRS DB’s on to Active node.

I know in standalone environments we can create SSRS services on one box and SSRS DB’s one some other box. But In my scenario SSRS services on standalone server and report server DB’s on
active node [On cluster node]. Can we do this ?

[May be you will say, why can’t I cluster SSRS by installing services on both the nodes. But my scenario is different and they don’t want to cluster SSRS].


Can you please let me know if you need any other details to resolve this.

Thanks in Advance,
Krishna
Post #1439147
Posted Sunday, July 28, 2013 1:01 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 3:36 AM
Points: 669, Visits: 380
Hi

this is perfectly possible. The SSRS config doesn't change. SSRS doesn't even know that its databases are on a clustered SQL instance.
Note that you will need an extra license though!

Chrz
Thierry
Post #1478333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse