How to Integrate Project Server 2013 with SharePoint Server 2013

By Danielle Arad - September 10, 2012
2 min read

You may have noticed that i’ve been working hard on the new 2013 templates. The latest is SharePoint 2013 with Project Server 2013. This post is about how to tie them together.

If you already installed and configured SharePoint Server 2013 and you would like to try out Project Server 2013 features there’s no need to install another SharePoint server. You can simply integrate between Project Server 2013 and SharePoint Server 2013 using an existing site collection.

Project Server 2013 runs as a service application under SharePoint Server 2013. In order to integrate between those products, Project Server 2013 must be installed on each application server in your SharePoint farm. This blog post will explain the configuration process of Project Server 2013.

As usual, to save you some time I’ve already done the configuration for you. Access SharePoint Server 2013 with Project Server 2013 now!

  • First thing that has to be done after installing Project Server 2013 is to run the SharePoint Products Configuration Wizard. The wizard has to run on all application servers in your farm before you can start using Project Server.
  • Start the Project Server Application Service. Open SharePoint 2013 Central Administration -> System Settings -> Manage services on server.
  • Start the Project Server Application Service.
  • Create a Project Server service application. Open SharePoint 2013 Central Administration -> Application Management -> Manage service applications -> New -> Project Server Service Application.
  • Specify a name for the service application and choose an application pool.
  • Create a Project Web App database. Open the SharePoint 2013 Management Shell and
  • Use the following PowerShell cmdlet: New-SPProjectDatabase –Name DatabaseName -ServiceApplication “ServiceApplicationName” -DatabaseServer SQLServerInstance -Tag String.
  • For example: New-SPProjectDatabase –Name ProjectWebApp1 -ServiceApplication “ProjectServiceApp ” -DatabaseServer sp2013srv -Tag “ProjectWebApp1DB”
  • In order to make sure that the previous step worked you can open SQL Server management studio and check if the DB ProjectWebApp1 exists.
  • After you have created a new Project Web App database, the next step is to enable the Project Web App site collection features. Enabling these features will associate the database that you just created with the site collection.
  • Use the following PowerShell cmdlets using the same parameters you used :$web=Get-SPWeb SiteCollectionURL
    Enable-SPFeature pwasite -URL SiteCollectionURL
  • For example:
  • Add a Project Web App(PWA) site to the site collection. Use the following PowerShell cmdlets: New-SPweb -URL SiteCollectionURL/PWASiteName -Template pwa#0Upgrade-SPProjectWebInstance -Identity SiteCollectionURL –Confirm:$False
  • For example: New-SPweb -URL http://sp2013srv/PWA -Template pwa#0
    Upgrade-SPProjectWebInstance -Identity http://sp2013srv -Confirm:$False

That’s it! Project Server 2013 and SharePoint Server 2013 are integrated and configured.