asked
Reporting server issue
Hello Everyone, We have 2 node cluster and on which SQL Server Reporting service has been install on one one node only. so when ever the SQL Resource fail from one node to other the service get stop and application fails... What could be the possible solution for the same. ( Can we install the reporting service on other node ) and how could we install the same.
This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
For this the version and edition matters a lot. If you are running on appropriate version and edition (check on MSDN for cluster aware ssrs version) you can add SSRS service as a cluster resource similarly as you have added sql server service, disk group etc... Since SSRS is cluster aware it will be able to move along with node switch once added as a cluster resource. Also, FYI if you are running in Active/Active cluster mode the licensing cost will be for each node unlike the Active/Passive clustering model. Hope this helps.
Reporting Services is **NOT** cluster aware. Some information on how you could make it work: [1][1] [2][2] [1]:
http://www.mssqltips.com/sqlservertip/2778/how-to-add-reporting-services-to-an-existing-sql-server-clustered-instance/ [2]:
http://www.sqlservercentral.com/Forums/Topic431921-146-1.aspx
17 People are following this question.
