Google
 

Tuesday, October 2, 2007

Upgrading from CTP4 to RTM PerformancePoint 2007

A good posting from the newsgroups on upgrading PerformancePoint to RTM.  The question was "Do you have to uninstall CTP4 to install RTM?"

  Yes, that is the upgrade path for the "Planning Server".  Note that you do *NOT* want to drop the Databases after you uninstall, as you will be re-using them.  When you run through the RTM Configuration Manager you would choose a "Distributed" installation and Un-Check the Database Install option, this will allow you to "Attach" to the DB's... if the option is selected PPS will attempt to create the DB's for you, which is not what you want, and, since yours already exist, would fail.

  Installing RTM will "upgrade" the Planning Server's System and Service Databases automatically for you, if you have any Applications, you will need to upgrade those after the fact using the PPSCMD, (which is installed with the Business Modeler), "Upgrade" option, (you can type PPSCMD help Upgrade" on the command line for more info... by default, PPSCMD is installed here: "%ProgramFiles%\Microsoft Office PerformancePoint Server\3.0\BizModeler".

  The entire process should be in the Deployment or Operations guide, (which is up on the TechNet and Office Online PPS sites).  Note that after this has been done, you "may" need to go in and re-grant your SI Account some permissions... it depends on how your present system is setup.  The reason I say you "may" need to is because a "Distributed" install is considered by PPS to be a Production Environment installation, and as such certain permissions are not granted to the SI Account during Configuration of a Distributed Environment for security purposes... much the same way that after installing SQL Server 2005 your Remote Connections are not enabled by default. :-)  The Documentation should discuss this further. :-)

No comments: