I have recently seen this question on how many databases are created once the Project Server and Project Portfolio Server are installed? My first answer was: “it depends!” Here is why. Assume we are installing both Project Portfolio Server and Project Server on a SharePoint Server farm and that they all share the same SQL server instance:
“(n)” simply means that you could have multiple databases depending on your configuration (number of PWA instances for instance).
So in the end for one Project Web Access instance setup on a SharePoint Server farm with Portfolio Server and SQL Reporting Services all sharing the same SQL Server instance you will typically have 18 relational databases. If you have another PWA instance, other SharePoint site, other SSP, PerformancePoint Server, etc… expect additional databases… I recommend you carefully plan your EPM deployment and architect your solution based on the above recommendations and the latest TechNet content for all these products; involve a trained Partner as well if you are not familiar with all the products. So in summary “it depends” but hopefully this gives you a good starting point :)
PingBack from http://skmullen.wordpress.com/2009/01/27/microsoft-project-links-and-resources/
Great inventory, there's a good article on Project Server Deployment on the following blog: