Tuesday, January 3, 2012

Installing SSRS 2008 on a Cluster

Example:
Cluster Name\Instance = Cluster\A
Nodes = N1, N2
Other Server = O1

Do not install SSRS on Cluster\A
Use SQL Enterprise

Native Mode Install on Cluster - Single SSRS Server
- Install the SSRS on O1

Native Mode Install on Cluster - Scaled Out with NLB (allows multiple SSRS instances to work together to process reports)
- To do a scaled-out deployment that uses Network Load Balancing, you must install on N1
- Run the SSRS config and install the reporting database on Cluster\A to have the database benefit from clustering
- Now install on N2 and point to the reporting database on Cluster\A

Sharepoint Integrated Mode - ANY
- The machine you install SSRS on must have a Sharepoint product installed on it as well for it to communicate with your sharepoint farm.
- Once installed, go to sharepoint, then add Report Server add-in, point to SSRS instance

No comments:

Post a Comment