ssrs database on cluster, service on another server?
Hi, is the following possible: Install SSRS (service) on a standalone server and the databases on an already existing windows cluster, by using the clustername for the instancename? (assuming SQL cluster is already up and running). Yes, I know I have to start setup.exe with some parameters to disable cluster-checking. So I am NOT goin gto install the service on the cluster, just the database. Thanks!
Yes this is 100% supported. The database repository for SSRS can reside on any SQL Server instance (of the same version). I have this same configuration in place. This is no different than having multiple SSRS instances for load balancing pointing to the same database repository. Although SSRS is not cluster aware, SQL Services is. The only gotcha in this setup is that when you install the SSRS front end on another server besides the database server, you will have to license the SSRS front end. Hope this helps.