question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

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!
ssrsclustering
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tim avatar image
Tim answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.