Storage Software
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL 2005 Reporting Services under HP PolyServe

BlackHawkEH!
Occasional Advisor

SQL 2005 Reporting Services under HP PolyServe

Has anyone configured SQL 2005 Reporting Services under PolyServe?

It seems to work with Enterprise Edition but not Standard. It, SSRS, assumes we are setting up a scale-out/load balanced architecture rather than a fail-over configuration.

As a result I can have the dB move around but the Reporting Services are limited to running on only one node. Or at least only can be configured on one node under Standard Edition.
Binary: easy as 1, 10, 11
5 REPLIES
EricSP
Advisor

Re: SQL 2005 Reporting Services under HP PolyServe

BlackHawk, did you ever get an answer for this? I'm dealing with a similiar problem
BlackHawkEH!
Occasional Advisor

Re: SQL 2005 Reporting Services under HP PolyServe

Basically there is nothing PolyServe can do about it. It is a limitation of Standard Edition.

Only Enterprise will support failover under PolyServe.
Binary: easy as 1, 10, 11
EricSP
Advisor

Re: SQL 2005 Reporting Services under HP PolyServe

Thank you BlackHawk, I wish the PolyServe documentation provided a note explaining this, so I wouldn't have wasted my time trying. I figured since all we wanted was fail-over the Standard Edition would be enough.
Dan Tyndale
Advisor

Re: SQL 2005 Reporting Services under HP PolyServe

Yup, a Microsoft limitation

This article says that SQL Server Standard edition does not support SSRS Scale out.
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
If you follow the instructions for the poly deployment and the deployment for the scale out deployment you will see they are almost the same.
http://technet.microsoft.com/en-us/library/ms159114(SQL.90).aspx
bob dutton_1
Occasional Visitor

Re: SQL 2005 Reporting Services under HP PolyServe

Polyserve uses the shared database which is the scaled out deployment so no Polyserve does not support the standard edition.
This article says that SQL Server Standard edition does not support SSRS Scale out.
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
If you follow the instructions for the polydeployment and the deployment for the scale out deployment you will see they are almost the same.
http://technet.microsoft.com/en-us/library/ms159114(SQL.90).aspx