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.

Search Server in Stopping state

I have found some errors when trying to stop the search server when there is a bad configuration and the crawling never ends. This is how we solved it when the service hangs in a “Stopping” state.
Errors and solutions:
1.Try to stop and restart the service:
Net stop osearch
Net start osearch
2.Try to kill the current processes
Stsadm –o osearch –action stop
Stsadm –o osearch –action start
3.Try to kill the processes from task manager. The processes will be processing by the search service user.
4.Stop the service and kill the processes (1&2) and then go to your sqlServer and open the Activity job. Kill all processes which are using your crawling user which will be the processes which are hanging your server. Then restart the service.
Hope it helps!