EPM, Project Server 2003, Project Server 2007, MOSS 2007, Portfolio Server2007
Well, you just have a brand new database server and you need to move all the databases from your old SQL server to the new SQL server.
This is what I did to change the SQL server instance of an existing EPM farm.
You cannot just backup and restore (or detach it) the databases. This is because the configuration database of your farm cannot be restored to a new SQL server. You have to use the backup/restore tools described here for EPM : http://technet2.microsoft.com/Office/en-us/library/8aee655b-1f87-4729-bf30-e79ad0debeec1033.mspx?mfr=true
This farm is configured with two separate servers: one web/application server and one sql server..
Enjoy your new SQL server !
In a next post, I will detail what you need to manually redo in your restored envirornment, depending on your original configuration.