I have an environment of 15 servers in VCS cluster, when 7 nodes are active nodes, one directory.
SQL on 2 nodes where directory and 5 EV DB's are on one SQL server and the rest of EV DB's are on the second SQL server.
My client is interested in implementing reporting services.
Since this is not a small environment, I would like to ask for your ideas on how would you have implemented reporting services in environment such this one.
Does reporting services requires access to all EV DB's? can it be implemented if DB are spread on more than 1 server?
does reporting services can be installed in VCS clustered environment? since I know it is not supported in Microsoft environment.
Would appreciate to hear your opinions in that matter :)
Solved! Go to Solution.
I would recommend to install SQL RS on a seperate machine, e.g. a VM.
Reason is that RS can be a real pain to get rid of if you need to, or re-installing RS can be a real pain if something doesn't work during installation.
Which probably isn't what you want to risk in a "live" environment.