locked
PerformancePoint and SQL Server 2008 RRS feed

  • Question

  • Hi all,

    I have a single box with SQL 2005 (SQL, SSRS & SSAS) , WSS 3.0 and PPS SP1 installed but would like to run SQL 2008 instead beacuse of some of the Reporting Services improvements.

    On a test box, it appears that SQL 2008 & PPS SP1 do "play nicely". I've not done an exhaustive test yet and my investigations are continuing, but I was wondering if anyone had any experiences of where they do not work together.

    From the SP1 release notes in this forum, it says:

    No longer blocked from using SQL Server 2008 as a data source (NOTE: full support for 2008 is coming in SP2, we just won’t prevent you from running on it with SP1)

    My plan is to do a complete rebuild of the box to start from fresh.

    Thanks in advance,

    Matt

    Wednesday, November 12, 2008 11:18 AM

Answers

  •  

    I posted the links for the hotfixes needed for PAS 6.3 to work with SQL Server 2008 -

     

    Download details: PAS 6.3.2216

    Download details: PDP 6.3.2216

     

    As far as the planning side of things goes I am uncertain and that could be one of the main items that would be resolved with the SP2 patch coming in December (hopefully).  I haven't done a lot of research on the planning portion working with SQL Server 2008, so maybe someone else could comment on that portion. 

    Thursday, November 13, 2008 3:48 PM

All replies

  • As long as you have the requirements installed for PPS M&A you will be fine.  Make sure you have all of the SQL Clients and Providers in the list for 2005 (9.0) installed.  Everything will work fine with PPS M&A on SQL 2008.  The full support will come in PPS SP2 later in Dec.  The only thing with M&A that isn't really work as it should is with SSRS 2008.  To use the SQL Report as a Report Item and reference a SSRS 2008 deployed report you can either use the Web Page or you can use the SQL Report, but you have to select the integrated mode even if it is running in native mode -- see this blog posting here Performance Point Server - Integrating SSRS2008 Report View.

     

    System Requirements for PPS 2007

  • Microsoft Internet Information Services (IIS) 5.1 (XP) 6.0, or IIS 7.0 with IIS Metabase and IIS 6 configuration compatibility, IIS 6.0 Isolation Mode
  • Microsoft .NET Framework 2.0
  • Microsoft ASPNet 2.0
  • Microsoft ASPNet AJAX 1.0
  • SQL Server 2005 Analysis Management Objects 9.0 SP2
  • SQL Server 2005 Native Client 9.0 SP2
  • SQL ADOMD.NET 9.0
  • msxml6.msi + updates
  • SQL Server 2005 SP2 Analysis Server OLEDB 9.0 Provider
  • SQL Server 2000 Analysis Services Service Pack 4 - Build 2174 for Client Systems (to use SQL Server 2000 Analysis Services as a data source)

     

    If you need any of the SQL Server 2005 requirements you can get them from the feature pack.

    Feature Pack for Microsoft SQL Server 2005 - February 2007

     

    Don't forget the AJAX 1.0 install.

     

    If you will be setting up PAS you need to make sure you are on hotfix 2216.

    Download details: PAS 6.3.2216

    Download details: PDP 6.3.2216

     

    You might also want to consider the CU1 for SQL Server 2008 also, quite a long list of fixes.

    Cumulative update package 1 for SQL Server 2008

Wednesday, November 12, 2008 12:56 PM
  • Dan,

    That's great thanks. Do you know if Planning and running ProClarity Analytics Server 6.3 will be okay on SQL 2008 too?

    Matt
    Wednesday, November 12, 2008 6:53 PM
  •  

    I posted the links for the hotfixes needed for PAS 6.3 to work with SQL Server 2008 -

     

    Download details: PAS 6.3.2216

    Download details: PDP 6.3.2216

     

    As far as the planning side of things goes I am uncertain and that could be one of the main items that would be resolved with the SP2 patch coming in December (hopefully).  I haven't done a lot of research on the planning portion working with SQL Server 2008, so maybe someone else could comment on that portion. 

    Thursday, November 13, 2008 3:48 PM
  • Dan,

    That's great. Thanks for your help.

    Matt
    Thursday, November 13, 2008 8:41 PM