| Step 1 |
| Step 2 |
| Step 3 |
| Step 4 |
| Step 5 |
| Step 6 |
| Step 7 |
| Step 8 |
Step 9 |
Step 9: Create New Project Web App (PWA) Site
Note: The following instructions are only applicable, if you already installed SharePoint Server 2013, Project Server 2013 and created top-level site collection to host your Project Web Access instance.
Project Server 2013 has capability to host multiple PWA sites on same farm. The following section describes the creating first PWA site on your Project Server 2013 instance.
When you create a Microsoft Project Web App (PWA) site, the required Project Web App database will be created automatically on the instance of Microsoft SQL Server that you specify.
PWA creation will prompt you to enter the name for project server database. PWA instance also associate with one content database which was created as a part of your Project Server 2013 installation or New Web Application creation process.
PWA creation will prompt you to specify the web application name to host PWA, Name of the PWA, Administrator account, and Database Server name.
NOTE: Microsoft recommends that you use a separate SharePoint Server 2013 content database for each PWA site. In order to deploy the PWA site to a specific content database, you have to lock down any existing content databases in the farm.
The process does not affect user access; it only affects the distribution of new site collections. Please read the document on Microsoft site for the steps required to
lockdown the existing content databases.
Steps to lock down the content database:
In SharePoint Central Administration, in the Application Management section, click Manage content databases.
In the Database Name column, click the link for the content database that you want to lock.
In the Database Capacity Settings section:
In the Number of sites before a Warning event is generated box, type 0.
In the Maximum number of sites that can be created in this database box, type 1.
Steps to create a Project Web App (PWA) site:
- In SharePoint Central Administration, in the Application Management section, click Manage service applications
- On the Manage Service Applications page, click the Project Server Service Application
- On the Manage Project Web App Sites page, click Create Project Web App Instance
- Enter the required information to create the PWA site
- Click OK
Project Server starts the PWA site creation process. This may take some time.
When the site creation process is complete, the status will be display as "provisioned".
Click on PWA URL to view the site.
NOTE: Once the PWA site has been provisioned, verify that it was created in the content database that associated with web application used in PWA creation.
Steps to determine name of the content database associated with PWA site:
- Click Start -> All Programs -> Microsoft SharePoint 2013 Products -> SharePoint 2013 Central Administration to launch the Central Administration page
- In Central Administration, in the Application Management section, click View all site collections under Site Collection section
- Highlight /PWA to view the content database name
- The above screenshot indicates, PWA site collection is using content database named WSS_Content_PWA
After you confirmed the Project Web App site is in the desired content database, you must lock down the content database to prevent SharePoint Server 2013 from adding additional site collections to the database. (FYI: Microsoft recommends that you use a separate SharePoint Server 2013 content database for each PWA site.)
To enforce the practice to have only one PWA site collection in one content database, we must lockdown the content database to prevent adding the new site collections to this database. This is performed by configuring the maximum number of sites for the content database to one.
Step 10: Project Server 2013 Reporting Configuration