none
how to use PPS 2007 with SQL Server 2008 already installed RRS feed

  • Question

  • Hi all,

    I  installed SQL Server 2008 and i planning now to install PPS 2007 and connect to SQL Server 2008 what i know that SP2 will help to connect to SQL 2008 but must install befor SQL Server 2008 any way to make PPS working with SQL Server 2008 without reinstall SQL
     
    thanks in advance 


    Volcano , "DATA is the Focus, Business is the Target”"
    Sunday, December 28, 2008 11:27 AM

Answers

All replies

  • You should not have any issue doing this and this is how I setup all of my environments.  Just make sure that you have all of the necessary SQL 2005 componenets (Microsoft ADOMD.NET, Microsoft SQL Server Native Client, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft SQL Server 2005 Management Objects Collection) installed and then SP2 for PPS 2007 prior to going through the configuration tool.

    Install PerformancePoint Monitoring Server with SQL Server 2008


    Feature Pack for Microsoft SQL Server 2005 - December 2008


    Service Pack 2 for Microsoft Office PerformancePoint Server 2007

    Dan English -- http://denglishbi.spaces.live.com
    • Marked as answer by sql_guy Sunday, December 28, 2008 2:32 PM
    Sunday, December 28, 2008 2:00 PM
  • Hi Dan,

    mean once i install SP2 will working fine with SQL Server 2008  

    thanks
    Volcano , "DATA is the Focus, Business is the Target”"
    Sunday, December 28, 2008 2:03 PM
  • Yes, install the SQL 2005 components from the Feature Pack link that I included, install SP2 for PPS, and then you will be able to use the configuration tool and complete the PPS setup without any issues.  You do not need SQL Server 2005, just the 4 components that you can download and you will need SP2 for PPS installed before trying to configure PPS.
    Dan English -- http://denglishbi.spaces.live.com
    • Marked as answer by sql_guy Sunday, December 28, 2008 2:32 PM
    • Unmarked as answer by sql_guy Sunday, December 28, 2008 2:32 PM
    Sunday, December 28, 2008 2:14 PM