Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Manually create Project Server databases

Project Server 2010

Published: July 8, 2010

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) (http://go.microsoft.com/fwlink/p/?LinkId=195945).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.