viernes, 24 de julio de 2009

Migrating PPS from one server to another

Hello,
I'm now working with Project Portfolio Server so, during this days I will write some posts about it.
The first scenario thah I have found is a migration from one Project Portfolio Server to another server. How to migrate that?.
I have follow this steps:

1- Make a database backup using Sql server Management Studio of PPSAccountData and PPSAccountIndex databases.

2- Restore them in the new Sql Server. In my case I have to install the databases in one server, MOSS 2007 and Project Server 2007 in three servers (1 WFE & 2 APP. Servers), and Project Portfolio Server in another server.

3- Install PPS in the new server. I found that if I install PPS with SP1 it gives the message "Cannot find database PPSAccountIndex". So you have to install the version without SP1 and then install SP1.

4- Once It has been installed see if you can log on as superuser. In my installation I couldn't log on, so I had to modify the web.config file:
add key="AccountID" value="-1"
with
add key="AccountID" value="1"

5- Then I tryed to connect It with Sharepoint. When I modifyed user credentials in the preferences section I found the next error:

"Cryptographic Exception"

To solve it you have to delete the cryptographic key using this SQL sentence over the PPSAccountIndex database:

DELETE FROM sfSETTINGS WHERE (Name LIKE '%key%')

Once you do that you can connect to Sharepoint Server.