Microsoft Project 2007

Server Administration
Overview

Adrian Jenkins
Supportability Program Manager
Project
Microsoft Corporation
Agenda
Show the integration with WSS
Broad overview of Administration
functions in Project 2007 Server
Highlighting differences from Project 2003
where possible
Different types of Admins
Central Administration
Overall Farm admin
SSP Admin
Manages whole SSP
Creates/Deletes Project Server Instances
Project Server Instance Admin
Manages project data
Sometimes all are the same person
Project 2007 Topology WinProj

Central
SSP
Web
Farm Front
config
AdminEnd
database WSS
The “Backend”
Hosts
Project
Used to
the
2007
manage
content
config Site
VServer
data
the topology
in WSS
Project Serverconfig
and
DB
related
PWA
Also the
provisioned
place toas WSS
PWA
Site Content
a Replaces
infrastructure
create
Site P2003
the Shared DB
registryProvider
Service keys
Queue
Project workspaces WSS
Copy on every box PWS Site PWS
created
in the here
Timer farm
Databases
Synced by Timer Content VServers)
service

C.A. Site Project Other

Proj Server Shared
Config DBs
DB Interface Services

Central Admin Shared Service Provider

Central Administration
Main Admin page for WSS Farm
Administration
Farm level administration
Product level administration
Central Administration
Shared Service Provider
Application Servers
Allows Services to be shared
between virtual servers
For example Search can be a
Shared Service
VServer 1 VServer 2 VServer 3

Project Server
Shared Service Provider
Project 2007 Server
Instance Administration
Project Server Instance
Instance defined by relationship
between Project Web Access and it’s
associated databases
Can have multiple instances per
application server (in hosting)
Can have instances with their own
application server (out hosting)
Administration is very similar to
Project Server 2003
Admin - Goals
Reduce clicking, where sensible
Click on entity to modify
Multi-select
Save/Cancel buttons on top/bottom
Reduce (not eliminate) use of ActiveX
controls
Consistency
With Project
With WSS
Quick Quiz…
Question:
Where do you set the
Active Directory Resource Pool
Sync settings?
Answer:
Under ‘Server Configuration’
Improved Administration…
Security
Manage Users
Search on name or email address
If number of users <500 then will
display all
Paging supported
Manage Users
User Authentication
Forms Authentication
Resource editing in place
Currently selected item text
Permissions grouped logically
System Identification Information
Manage Groups
No significant changes over Project
Server 2003
Manage Categories
New RBS setting
Views brought together
Field Access Control
Ability to restrict access to fields within PWA
Fields
Non-custom cost
All project, task, assignment & resource cost fields
Non-custom baseline fields
All baseline (0-10) and associated earned value fields
Local custom fields
Enterprise custom fields
Access
No Access – Can’t view through this category
Read
Read/Write
Deny – Can’t view through any category
PWA Permissions
Known as organizational
permissions in 2003
Allows an Admin to deny a feature
across the server
2003 - Buried deep within
‘Server configuration’
Project 2007 – has it’s own section
under Security
Enterprise Data
Enterprise Custom Fields
Create enterprise custom fields/lookup
tables on the server
E-Global no longer used
Unlimited enterprise custom fields
Need Professional and ActiveX control
installed to validate formulas
Enterprise Global
It’s really just “Configuring Project Professional.”
Calendars and enterprise fields no longer “live” in
the e-global
E-Global now used for
Fields
Grouping
Toolbars
Maps
Forms
Tables
Filters
Views
Reports
Modules
Enterprise Calendars
Need to edit them in Professional
Doesn’t require e-global
Can edit individually
Non-Working time
Create Administration time category
Creates a resource calendar exception
Can require approval
About Project Server
Think of it as a mini CAL tracker
Number of Project Web Access users
Active
Allowed to ‘Log On’
Number of Professional users
Active
Allowed to ‘Log On’
Have ‘Log on to Project Server from
Project Professional’
Database Administration
Delete Enterprise Objects
Multi-delete!
Cleaned up UI
Force Check-in Objects
2003 - UI was split into check-in
Projects and Resources
Project 2007 - Consolidated UI
Can check-in Projects, Resources,
Custom Fields, Calendars, Lookup Tables
and Resource Plans – all at once.
Queued operations
Backup And Restore
Takes the place of 2003 “Restorep.exe”
A mechanism to recover from a “whoops”
situation.
Retention policy only applies to Projects
Only one copy of such as enterprise resource is
kept
Will only backup changed Projects
Server API allows you to set the policy for
individual projects, but UI is uniform across all
projects
Server API allows you to set whether or not a
backup can be overridden.
Only from Working store
Backup And Restore
Latest copies of all others from
Published store
Copies data into Archived database
Restore
Projects will copy over what’s there
Resources will replace/restore but won’t
remove Resources from Published store
Report database does not get
information from Archive database
Look And Feel
Manage Views
Project 2003
5 types of view – Project, Project Center,
Assignment, Resource Center,
Portfolio Analyzer
Project 2007
10 types of view – Project, Project Center,
Resource Assignments, Resource Center,
Data Analysis (Portfolio Analyzer), My
Work, Resource Plan, Team Tasks, Team
Builder, Timesheet
Grouping & Gantt Chart
Formats
No difference from Project Server 2003
Quick Launch
Add links to other web pages
Can hide links
More information in D320
Cube
Cube Building Settings
Tidied up UI
Similar to Project 2003
Timer job for Cube Building Service
(CBS) update
Cube Configuration
Customize using Custom Fields
New in Project 2007 Server
MDX calculation
Calculated measure
New in Project 2007 Server – not really
possible in 2003
Validated when cube built
Offers weekly time dimension
More covered in PMP320
Cube Building Status
Log of cube building
5 build stages
More information bubbled up to the UI
in Project 2007 Server
The entire cube building process is much
simpler in Project 2007 Server
Therefore, there are fewer places for the
process to fail.
Time And Task Management

Whole section covering timesheets,

day 2 in session OAP220
Queue
Manage Queue
Shows status of Queue
Can filter view to show/hide
specific jobs
Allows cancelling/retry job
Queue Settings
Max threads
Polling interval
SQL retry interval
SQL retry limit
Operational Policies
Additional Server Settings
Catch all page
Enterprise Settings
Currency settings
Resource Capacity storage in reporting
database (RDB)
Reporting server URL
Project State field
Alerts And Reminders
Setup e-mail
Specify SMTP server
E-mail address
Default message
Schedule reminder
Event Handler
Configuration
Allows a user to specify what
assemblies to use for handling
server events
More information in D310
Project Workspaces
Creation and Deletion of PWS sites
Edit site address
Synchronize users
Project Workspace Settings
Default Web Application
Default workspace properties
Auto Provision
Permissions
STSADM Integration
STSADM is the WSS command line tool
Project has extended it
Scoped set of functionality
Manage Project Server Instances
Manage Users, Groups and Categories
Backup and Restore
Tool has to be run on the
physical server
Remote access only through Terminal
Services
Active Directory
Synchronization
Feature Overview
Use existing AD infrastructure for
User/Resource Creation
Membership synchronization
Metadata updates
Control resource status
Automate User And
Resource Creation
AD Sync Admin

Enterprise Resources AD Group

Map ERP to AD group ERP

AD group members => Member Member

Enterprise Resources
Administrators
PS-Administrators

Project Server Users

Executives
Map AD Group to Project PS-Executives

Server group
Project Managers

AD group members become PS-PMs

new PS users Project Server Groups AD Groups

Metadata Updates
Out-of-box
Resource/User Name (displayName)
E-mail Address (mail)
Group (Department)
Windows User Account
Resource GUID (objectGUID)
Customizable
AD Sync in Project 2007
Faster
New find group UI
Automatic resource reactivation
More intuitive user exclusion process
Initiate AD sync from any computer
No group size limits
True cross forest support
Custom AD field mappings
No AD Group Size Limits
LDAP Policy limits
1000-1500 group
members retrieved Total 4500 Users

at a time
Project “12” uses
range retrieval 1500 Users 1500 Users 1500 Users

Nesting still
supported

Single Group (4500 Users)

True Cross-Forest Support
Sync to groups in external forests
Sync to group members in external forests

Member -LocalForest

Member -RemoteForest
Member-RemoteForest

Member -RemoteForest
AD Sync AD Sync

Group-LocalForest
Group -LocalForest Group -RemoteForest Member -RemoteForest
Member-RemoteForest

Project Server Member -RemoteForest

Member -RemoteForest
Member-RemoteForest

Forest A Forest B
Custom AD Field Mappings
Use AD Sync server-side events to
Map any AD field to any Project
custom field
Control special character replacements
“[“ and “]” replaced by “{“ and “}”
List separator (“,”) replaced by “;”
Control duplicate name handling
Conclusion
Work split between Central, SSP, and
Project Instance administration
Project Server Instance Administration
not radically different
Some nice improvements
Deeper integration with WSS
 © 2006 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.