MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

ssrs editions and version matching

  Asked By: Marques    Date: Jan 03    Category: MOSS    Views: 839

We recently integrated performance point monitoring server into our sharepoint 2007 enterprise farm.

We have 2 web servers and 1 application index server in the sharepoint farm, with a sql cluster. All servers running server 2008 and sql is 2008 standard.
With the installation of monitoring server we bought another seperate sql server that is running windows 2008, sql 2008, database services, reporting services, integration services and analysis services. This sql is 2008 but with sql enterprise.

So on the web servers we have ssrs and the add-in installed for 2008 and it all works fine. The ssrs on these servers are setup as scale out deployment and running enterprise ssrs.

Is it required that the ssrs running on the sharepoint web servers be enteprise edition to match the server that handles the reporting which also is sql server 2008 enterprise?

We tried it with sql 2008 standard on the web servers but never worked, but it works fine now with matched editions and versions of sql. Just want to make sure as enterprise sql can be costly.

Is there some microsoft articles to backup the matching of editions for this scenario?



1 Answer Found

Answer #1    Answered By: Jagdeep Hor     Answered On: Jan 03

PerformancePoint may be a Client Requirement but it isnt a pre-requisite to installing SSRS integrated  SharePoint mode...

The SSRS Dbs will be hosted on the SQL Enterprise server  regardless of where you install SSRS. SSRS does not have to use the Enterprise version. However, since the client purchased SQL Enterprise ad there isnt another cost for SSRS as long as you deploy SSRS on the same server as you have previously installed SQL, you may want to keep them the same..... You can actually iuse SSRS 20058 with SQL Server 2005

Didn't find what you were looking for? Find more on ssrs editions and version matching Or get search suggestion and latest updates.