It’s a rite of passage within every Project Server implementation. At some point, I sit down with the SharePoint administrator and brief them on what it is exactly that they’ve gotten into it – what exactly they’ll be supporting going forward. Sometimes it’s part of the demo process. Sometimes it comes much later. Here’s the discussion in written form.
Top ten things a SharePoint Administrator should know about Project Server 2010 (in no special order):
1) Project Server schedule data resides in an additional 4 databases for each instance of PWA provisioned. These databases need to be included in your disaster recovery plan, and are accessible from the Central Administration Farm Backup page. Collaboration content is stored in your SharePoint content database. A full backup/restore plan will need to accommodate all 5 databases – more if you plan on deploying multiple Project Server instances. Note also that search will natively index any site based content, but will require the configuration of External Content Types to index the Project Server databases.
2) Despite its name, the Project Web Application is a site collection. PWA is the top level site in the site collection. However, PWA should never be the top level site collection within a Web App. There should always be a top level site collection within the Web App, even if it’s a simple team site with security blocking anyone from accessing it.
3) The security structure within PWA is separate from the SharePoint security structure. Project Server maintains its own pool of users, which may be drawn from AD or other authentication mechanisms. That pool is managed in its own interface. This pool controls access to the main PWA site, and may be used to drive security on the individual project collaboration sites (see the next point).
4) Each project creation event may/may not provision a collaboration site (depending on the Project Server configuration). The project collaboration site is essentially a plain old team site with the Project Server feature activated. That site may be hosted within the PWA site collection or, with some configuration, outside of the PWA site collection. Security on these sites may be automatically managed from within Project Server or that linkage may be turned off and replaced with a traditional SharePoint security model in cases where the organization has policies requiring AD-based security on SharePoint sites. The same governance discussion that took place around your original farm needs to take place around these sites, i.e. disaster recovery and document retention policies, particularly as these sites are often intended to be transitory sites that get decommissioned at the end of the project.
5) Project collaboration sites may be edited within specific limits. Most organizations decide to customize the default project site template – which indeed can be mapped to specific project types for the automatic provision of differently branded sites. Content types do not come provisioned by default but may be easily implemented within the project site. Four lists/libraries are provisioned as part of the Project Server feature: Deliverables, Issues, Risks and Project Documents. Those entities may be edited, but do so with caution. Project Server expects to see specific fields attached to each item within those lists and libraries. Those fields may be hidden, but not deleted – and additional fields may be added as needed. The Project Server feature also provisions a number of Web Parts to surface Project Server data.
6) Project Server requires SharePoint Enterprise features (and the concomitant licensing requirements). The upside of this is that Project Server relies on all of the SharePoint reporting tools to report against the Project Server databases. Excel Services, PerformancePoint and SSRS may all be used, with the Project Server database providing your data source. Project Server also provides the feature to optionally build OLAP cubes of project and resource data, which may in turn be used to provide additional data to reporting tools.
7) Patches are released on the same frequency as SharePoint patches. In fact, patches are bundled with the bimonthly Office Server cumulative updates and service packs. That being said, patching Project Server is a bit more sensitive as you should generally try to ensure that all client installations of Microsoft Project Professional are patched at the same time as Project Server.
8) Users need a client access license (CAL) to access Project Server. More importantly perhaps, users need a CAL to access Project Server data. As always, when in doubt about licensing issues, always refer to your Microsoft licensing specialist, but the rule of thumb that I’ve always followed is that if they are accessing real time data from the Project Server database, they need a CAL. This means that even if you’re surfacing Project Server data via External Content Types into an External List on a non-Project Server farm, you still need a CAL to access that list. The corollary to that rule that I learned recently is that for the most part, if you need to ask whether or not you need a CAL for a specific scenario….you need a CAL.
9) Project Server may be deployed on the main corporate intranet or within its own farm. Architecting a Project Server deployment is a discussion that needs to happen early on in the process. Consider whether the benefits of making Project Server available to the sites on your intranet outweigh the benefits of deploying Project Server to its own isolated farm. Check online for a number of discussions around this topic.
10) Do not try to implement Project Server on your own. Always consult with your local Enterprise Project Management implementation partner even if it’s just to put together a couple of roadmapping sessions. Simply standing up Project Server with a “build it and they will come” approach almost never works.
That’s my list. What’s on yours?
Good stuff as usual, Andrew. Point number 10 is very important. I’ve worked on many remediation projects that started as a “this can’t be that hard, it’s Microsoft…like Office” and actually forced a step back because users didn’t know what to expect, how to use it and how to get value from it.
Pingback: Lo que un administrador de SharePoint debería saber sobre Project Server - JUAN PABLO PUSSACQ LABORDE
Pingback: The Epistemological Year in Review: Top Ten Posts of 2011 | Project Epistemology
Great article! Just wondering, is it possible to migrate Project Server 2007 to SharePoint 2007? Even though we might lose some features and functions, but could we be able to migrate the data into SharePoint so that we be able to access Project Server documents and lists in SharePoint? Is it possible to keep version history as well? What issues will we encounter? Thanks in advance!
Good question. Not sure what the answer is…but I suppose you could always turn off the Project Server features on a workspace to see what breaks.
Great post. Thank you. Question for you – do farm level solutions that were built for SharePoint (built on the SharePoint 2010 Server Object model) just work with sites/libraries/lists within the Project Server web app? Or are modifications required?
Good question. For the most part, I haven’t seen many issues. You might want to watch out for a couple things: The Project Server lists have a different list type ID (or whatever) than the SharePoint lists. So for instance, the SharePoint Issues list is of type 123, and the Project Server issues list is of type 000 or something like that (it’s been a couple years). So make sure if you reference that to account for it. Other than that, some PWA security settings may impact the user experience in the list, i.e. if you can’t access PWA, you can’t connect the items to tasks. Make sure you validate for stuff like that and you should be in ok shape.
Great Post,
Just kidding
Quick addition may be can be considered as #11
“Project Server is not just a service / site within sharepoint, it’s a complete application based on sharepoint platform”
Have often encountered this feel & had to explicitly clarify, DONOT consider PWA just as a sharepoint site / collection rather its a whole application in itself, if you do so you are shooting yourself in your leg
Pingback: SharePoint Conference Project Server BI Linkfest | Project Epistemology
Please eloborate 2nd point.
Typically when deploying Project Server 2010, you would create a Web Application. Within the Web App, you would create a top level site collection – and probably restrict access to the Admin. Then, you would create PWA as the second site collection within the Web App. Bad things happen when you try to implement disaster recovery and your PWA site is the top level site collection.
@ #10. Too bad there are no consultants around in NL that really know Project Server 2010 AND SharePoint 2010 AND the integration of both.
That’s like an engraved invitation to a flame war.