Skip to Content
0
Former Member
Nov 04, 2009 at 12:34 PM

Using SQL Server Reporting Services Standard edtion on the Web/App server

35 Views

I would like some clarification of when is it a supported configuration to use SQL Reporting Services Standard Edtion with BPC 7.0M.

If you have a standard Multi-server installation with WEB/APP/RS/IS on one server and SQL/AS on the other server, is SQL Reporting service required to be Enterprise Edition? The v7.0M SP4 installation guide is a bit confusing on this because it says Reporting Services standard edition is supported, but then it says that SQL Enterprise Edition is required on the web/app server.

The Web/app would have SQL Management tools (edition-independent), Integration Services (edition-independent) and Reporting Services (Standard is allowed?) - so that would seem to mean that you can have SQL Standard edition on the front-end Web/App server.

Please advise as to what we need to tell customers going forward.

thanks,

Tony DeStefanis