Transcript Project Server 2013 - administration for IT Professionals and PMO

SharePoint Admin, PMO
Direct access to the Reporting schema (dbo)
OLAP cubes
Minimum
IE8 or latest
version of
Firefox, Chrome
or Safari
Windows Server
2008 R2 SP1
Microsoft SQL
Server 2008 R2
SP1
SharePoint
Server 2013
Enterprise
Exchange Server
2013 (Optional) TechNet
Project
Professional
Windows 7 or 8
Lync 2010
(Optional)
Event
Receiver
SharePoint
Project
Azure
Workflow
Only one database per PWA instance
Setup and upgrade Project Server using PowerShell
Improvements in monitoring and troubleshooting through ULS logging, Dev Dashboard, diagnostic
views
Create PWA as a new site collection, or add Project to an existing site collection
Shared queue, eventing and calculation services across all PWA instances in the same Service
Application
Legacy project security model provides a lot of customization and flexibility
By default, new instances are in SharePoint permission mode (on premise and online)
Default groups and permissions map naturally to SharePoint’s model
Every instance requires a new site collection with the PWA web at the root
Users/Groups/Permissions need to be reconfigured from scratch
Workspaces are managed in a separate site collection
PWA can be added as a separate site (SPWeb) not at the root
Existing users can be just added to special project server groups
SharePoint tasks lists can be “promoted” to projects in Project Server
Download Complete
Download Complete
4 project databases + 1 content database
1 project database + 1 content database
New Site
Collection
New Project
Database
Associate the
site with the db
• Create a new site collection (SPSite) using PWA#0
• PWA is at the root (http://contoso.com/sites/pwa)
• Create a new Project Database
• The database is uninitialized
• Enable PWASite at the site collection
• The database is connected to the site and populated with
default data (groups, custom fields etc.)
New-SPSite –Url http://contoso/sites/contoso_pwa
-Template PWA#0
New-SPProjectDatabase –Name ProjectServiceDB
Enable-SPFeature pwasite –url
http://contoso/sites/contoso_pwa
New Site Collection
New PWA Site
New Project
Database
Associate the site
with the db
• Create a new site collection (template STS#0)
• Use lists, documents, tasks lists etc.
• Create a new PWA site (SPWeb) anywhere in the site collection
• Create a new Project Database
• The database is uninitialized
• Enable PWASite at the site collection
• The database is connected to the site and populated with default data
(groups, custom fields etc.)
New-SPSite –Url http://contoso/sites/PGMSite
-Template STS#0 -OwnerAlias domain\myadmin
New-SPWeb –Url http://contoso/sites/PGMSite/PWA
-Template PWA#0
New-SPProjectDatabase –Name ProjectServiceDB
Enable-SPFeature pwasite –url
http://contoso/sites/PGMSite
New-SPProjectServiceApplication, Set-SPProjectServiceApplication
New-SPProjectDatabase, Upgrade-SPProjectDatabase, Mount-SPProjectDatabase etc.
Get-SPProjectWebInstance, Mount-SPProjectWebInstance, Dismount-SPProjectWebInstance, UpgradeSPProjectWebInstance etc.
Setup permissions mode, queue settings, project calculation service settings etc.
TechNet: http://technet.microsoft.com/en-us/library/ee890097.aspx
Earlier versions can be upgraded through normal upgrade paths
During the upgrade process the 4 databases are converted into a single database (ConverttoSPProjectDatabase)
Upgrade the bits first and the database later
Read-only support – PWA is still accessible during upgrade and maintaince
http://technet.microsoft.com/en-us/library/gg502590.aspx
ULS based troubleshooting
Limited access to database
Improved quality coverage of logging
Integration with Developer Dashboard
Diagnostics Views
Great tool for analyzing the logs
Provides filtering and formatting capabilities
Download: http://archive.msdn.microsoft.com/ULSViewer
Can analyze web requests, service requests, and SQL calls
Easy to turn on and off
More info: http://msdn.microsoft.com/en-us/library/office/ff512745(v=office.14).aspx
MyPC fill out
evaluations
& win prizes!
www.msprojectconference.com