Video Screencast Help

EV Reporting on SQL cluster

Created: 10 Dec 2012 • Updated: 05 Feb 2013 | 2 comments
Sarah.Seftel's picture
This issue has been solved. See solution.

Hi

 

I have a EV reporting services installed on a stand alone SQL server.

The customer would like to move the DB to a default MSSQL instance dedicated to EV with the default name.

 

Anyone know if this is supported? as I know that EV reporting services is not supported in clustered SQL mode.

 

Sarah.

Comments 2 CommentsJump to latest comment

JesusWept3's picture

SQL Reporting services itself is not clusterable, but that being said the SQL Reporting databases don't need to be installed on the same SQL Server as the Directory database, and even then you *can* install reporting services on each individual node, it just won't fail over because it has no benefit of being clustered

you could even install the reporting services on the EV Server and have the reporting database on the same SQL Server as the directory or vault store database if you wanted as there is very little overhead, its purely up to you

SOLUTION
Saswata Basu's picture

JesusWept3 is right SQL Reporting Service is not cluster aware and does not failover. You will need to Install SQL Reporting Service on each node and then install EV Reporting option on each node of the cluster.

Remember to run the EV Reporting Configuration wizard on each node to deploy the reports.To access the reports use the url - http://<sqlclustername>/reports