question

basit 1 avatar image
basit 1 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.
failoverreporting-servicesfailed
1 comment
10 |1200

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

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.
0 Likes 0 ·
VishalhSingh avatar image
VishalhSingh answered
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.
2 comments
10 |1200

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

we are using SQL server 2005
0 Likes 0 ·
so it mean i need to install the SSRS on the other node.
0 Likes 0 ·
raadee avatar image
raadee answered
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
10 |1200

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

VishalhSingh avatar image
VishalhSingh answered
aah...I answered this thread thinking in mind as if we were talking about SSAS. thanks for noticing and correcting it.
1 comment
10 |1200

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

No problem, I guessed that SSAS was on your mind.
0 Likes 0 ·

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.