topic Re: SQL 2005 Reporting Services under HP PolyServe in Storage Software

SQL 2005 Reporting Services under HP PolyServe

BlackHawkEH! — Mon, 02 Mar 2009 20:33:36 GMT

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.

Re: SQL 2005 Reporting Services under HP PolyServe

EricSP — Wed, 07 Oct 2009 19:59:44 GMT

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

Re: SQL 2005 Reporting Services under HP PolyServe

BlackHawkEH! — Thu, 08 Oct 2009 11:03:40 GMT

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

Only Enterprise will support failover under PolyServe.

Re: SQL 2005 Reporting Services under HP PolyServe

EricSP — Wed, 14 Oct 2009 16:31:51 GMT

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.

Re: SQL 2005 Reporting Services under HP PolyServe

Dan Tyndale — Tue, 20 Oct 2009 15:48:29 GMT

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

Re: SQL 2005 Reporting Services under HP PolyServe

bob dutton_1 — Tue, 20 Oct 2009 16:23:27 GMT

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