Reporting services in big EV environment

[Sarah_Seftel1]

Hi all

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 :)

Sarah

[JesusWept3 · Accepted solution]

Reporting services will work just fine, it needs access to directory, audit, monitoring, vault store and fingerprint DB's, when you run the config though you just specify the directory DB and it gets the other DB's automatically As for clustering, reporting services cannot be clustered (at least on 2000 and 2005) so you would have to install the reporting services and deploy the reports on each node of the SQL server You could even install the reporting Services on the EV server if you wanted, the overhead really is t all that much, especially since it only provides data on demand, it is the monitoring and auditing that would be the biggest overhead as those are what populates the data required for some of those reports (such as items accessed and server health etc) But really you won't notice much of an issue given the size of your environment

[FreKac2]

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.

[JesusWept3]

Ah yeah freakac is right, to uninstall you have to completely uninsta SQL server then reinstall without reporting selected for installation

[Sarah_Seftel1]

thanks you for your insights :)

will install the RS on a new server that will be dedicated to this only.