Manually create Project Server databases
Applies to: Project Server 2010
Topic Last Modified: 2011-08-05
When you create a Microsoft Project Web App (PWA) site, the required databases are created automatically on the instance of Microsoft SQL Server that you specify. However, some organizations require that databases be created manually by a database administrator. This article contains the information that is required to manually create databases for Microsoft Project Server 2010.
The table that follows describes the collations required for each database used by an instance of PWA.
| Database | Collation |
|---|---|
Project Server Archive |
SQL_Latin1_General_CP1_CI_AS |
Project Server Draft |
SQL_Latin1_General_CP1_CI_AS |
Project Server Published |
SQL_Latin1_General_CP1_CI_AS |
Project Server Reporting |
SQL_Latin1_General_CP1_CI_AS |
SharePoint Server Content |
Latin1_General_CI_AS_KS_WS |
Have your database administrator create a set of databases, as described in the table, for each PWA site that you plan to deploy. Once the databases have been created, specify the names of these databases when you create the PWA site or the content database.
For information about how to create a database in SQL Server, see How to: Create a Database (SQL Server Management Studio) (https://go.microsoft.com/fwlink/p/?LinkId=195945).