Lydia Bronze

How to Integrate Project Server 2013 with SharePoint Server 2013

September 10th, 2012 | Author: | Filed under: Dev / Test, SharePoint | Tags: , , , , , ,


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 
    $web.Properties["PWA_TAG"]=”String”
    $web.Properties.Update()
    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.

 

About the author:
Lydia Bronze ( @LydiBee ) , Cloud Content Architect at CloudShare, is an experienced technologist with a diverse and deep background in infrastructure technologies, information security and technical training. Lydia's proven ability to architect, implement and provide solutions for advanced infrastructures using Microsoft and Open Source technologies makes her an invaluable asset to the team. She brings technical experience from a variety of industries, including the Defense and Finance sectors. In addition, Lydia has extensive SharePoint experience and has implemented corporate environments as well as custom SharePoint solutions for organizations of all sizes. Lydia is continuously seeking new challenges that will allow her to utilize her technical abilities.

  • http://twitter.com/cfiessinger ChristopheFiessinger

    Great post!

    • Lydia Bronze

      Thank you!

  • Hossein Aarabi

    Thanks Lydia. You post some of the best entries.

    Since the comments are closed on Juan Carlos’ post “What’s new in SharePoint 2013 CSOM?”. I want to mention that in his sample code the way his handling the exceptions is not the best practice catch exceptions in CSOM :)

    • Lydia Bronze

      Hossein,
      Thank you!
      Unfortunately I’m not a code expert, but I promise to deliver the message.

  • Alon Fluman

    Keep on the good work

    • Lydia Bronze

      Thank you Alon!

  • David

    Is it possible to do this with Project Server 2013 and SharePoint 2010?

  • asad

    Thanks for this great post. I am wanting to do exactly the same but when I try to enable the feature, it comes out with

    Enable-SPFeature : Failed to find Project Site object. Are there any database mounted?

    Any help would be highly appreciated.
    cheers

  • Pingback: Summarizing the year 2012 | Beetalks

  • Prasad

    Thanks Lydia for this great post.
    I’m new to Project Server 2013 integration with SharePoint 2013. I’m more curious to find out which site template SharePoint uses when it creates a new project site. Because I didn’t find any documentation on net regarding this. Few places it says that is PWA (which I think is Project web access) but is it the site template (such as STS#0, STS#1 etc.)
    Do you know anything about this?