Enterprise Project and Portfolio Management Delivery

Task Assignment in Project Server 2010

2011-02-27T00:42:00.004-05:00

There has been some scenario relating to Task status updates going to the EPM Administrator who create the Project and assigned a task to one Team member. However, during the course of time the Project ownership was transfered to a real Project Manager. Now after the ownership transfer occured the Team member updated his task and it directed to the Original Project owner (EPM administrator) who rejected the task.

Now This was a issue as it was not going to the Newly assigned Project Manager.

The resolution to this issue is simple:

Ensure the Project Manager opens the newly assigned project in Project Professional 2010 and Publishes it from his/her account; This will seal the ownership of the Project to newly assigned project manager and all previous pending task updates will now flow to this Project Manager.

Kinly let me know if you have any further questions on this item....

I hope this helps and assists you in your EPM / PPM Endeavor. Best Regards,Gokul Rajan

Project Server 2010 Software Requirements

2009-11-05T17:05:00.003-05:00

Also,

Determine hardware and software requirements (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

Project Server 2007 Version Finder

2009-10-20T17:41:00.001-04:00

The table below maps each release of Microsoft Project Server 2007 to its version number and corresponding KB article number. You can locate the latest version number for Microsoft Project Server, do the following:

In the Microsoft SQL Server Management Studio, run the following query.

USE <PROJECTSERVERNAME>_Published

SELECT * FROM Versions

WHERE VersionId ='00000000-0000-0000-0000-000000000000'

ORDER BY Id DESC

In the query above, replace <PROJECTSERSVERNAME> with your naming schema.

Project Server Release Name	Project Server Version Number	KB Article
Initial Release	12.0.4518.1016
January 31 Hotfix Package	12.0.6300.5000	941426
April 3rd Hotfix Package	12.0.6309.5000	950816
April 22nd Hotfix Package	12.0.6312.5000	951169
April 29 Hotfix Package	12.0.6313.5000	952000
May 8th Hotfix Package	12.0.6314.5000	952289
June 2nd Hotfix Package	12.0.6316.5000	953136
June 9th Hotfix Package	12.0.6317.5000	953478
Service Pack 1	12.0.6218.1000	936134
Infrastructure Update	12.0.6318.5000	951297
August 2008 Cumulative Update	12.0.6327.5000	956061
October 2008 Cumulative Update	12.0.6331.5000	957696
December 2008 Cumulative Update	12.0.6335.5000	960313
February 2009 Cumulative Update	12.0.6341.5002	968271
Service Pack 2	12.0.6422.1000	953334
April 2009 Cumulative Update	12.0.6503.5000	968860
June 2009 Cumulative Update	12.0.6510.5003	971502
August 2009 Cumulative Update	12.0.6514.5000	973937

To locate the version number for Microsoft Office Project Standard 2007 or Microsoft Office Project Professional 2007, use one of the following methods:

Method 1

On the Windows desktop, click Start, and then click Control Panel.

In the Control Panel, click Programs, and then click Programs and Features.

If the Versions field is not displayed in the Programs and Features list, do the following:

Right click the field header for the Name field, and then click More.

In the Choose Details dialog box, click to enable Version, and then click OK.

In the Programs and Features list, scroll down to location Microsoft Office Project Professional or Microsoft Project Standard 2007.

Method 2

Start Microsoft Project.

In the Help menu, click About.

Project client Release Name	Project client Version Number	KB Article
Initial Release	4518.1016
January 28th Hotfix	6300.5000	941657
March 22nd Hotfix	6300.5000	950284
April 30th Hotfix	6312.5000	952067
May 8th Hotfix	6314.5000	952293
Service Pack 1	6215.1000	937154
Infrastructure Update	6318.5000	951547
August 2008 Cumulative Update	6327.5000	956060
October 2008 Cumulative Update	6331.5000	958138
December 2008 Cumulative Update	6334.5000	959643
February 2009 Cumulative Update	6341.5002	966308
Service Pack 2	6423.1000	953326
April 2009 Cumulative Update	6503.5000	969409
June 2009 Cumulative Update	6510.5000	971501
August 2009 Cumulative Update	6514.5000	973930

Removing MySite functionality from PWA

2009-10-01T09:59:00.001-04:00

First, in order to follow these steps you will need administrator access to the SharePoint Central Administration site for your SharePoint installation.
Go to the Central Administration Web Page
Click on the link for Shared Services Administration
If you have more than one SSP, select the one that is running the My Sites functionality for your PWA instance.
Under "User Profiles and My Sites" click Personalization Services Permissions
Select the group you want remove the My Site/Links functionality from. In most cases this will simply be NTAuthority\Authenticated Users
In the next screen you will see a list of checkboxes,
1. To disable MySites uncheck "Create Personal Site"
2. To disable MyLinks uncheck "Use Personal Features"

Migrating Monitoring Server data from a test environment

2009-09-28T13:17:00.002-04:00

Migration of Monitoring Server from a test environment to a production environment is similar to the operation outlined in Backing up and restoring Monitoring Server databases.

Important:

Either Office SharePoint Server 2007 or Windows SharePoint Services must be installed in order to successfully install and use Monitoring Server. The terms Windows SharePoint Services and SharePoint Services are used collectively in PerformancePoint Server documentation to refer to Office SharePoint Server 2007 and Windows SharePoint Services 3.0.

Procedure

Install Monitoring Server on the target computer

Before installing the Monitoring Server on the target computer, confirm that you have successfully completed the steps in Backing up and restoring Monitoring Server databases.
Launch Monitoring Server Configuration Manager.
Specify the imported database on the target instance of Microsoft SQL Server 2005 by clearing the Monitoring System Database check box in the configuration wizard. Click Next.
Specify the name of the database you have exported.
Using Notepad, update the Web.config file on the target computer to match the previous ConnectPerUser and CustomData settings on the source:
- <appSettings>
- <add Key="BPM.ServerConnectionPerUser" value="False" />
- <add Key="BPM.UseASCustomData" value="False" />
Use Dashboard Designer to export the existing dashboards to the Windows SharePoint Services server installation.

Where SharePoint’s Config database is located

2009-09-16T15:02:00.001-04:00

Well, Here it is. SharePoint actually stores the connection to the configuration database in the registry.
HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB

Uninstalling Microsoft Office SharePoint Server 2007

2009-09-11T14:40:00.002-04:00

There is a easy way to Perform "Uninstallation of MOSS" on a standalone/farm server. The only viable way of doing things in standalone is follow the order below; However, for Farm based MOSS installation there are few more steps to be followed, which can guarantee clean removal of the software.

Steps to remove MOSS from your System/Server.

1. Remove Server from Farm

In Central Admin, Operations tab, Server in farm -- Remove server.

A word of caution: Always remove the Database / SMTP Servers first before removing the SharePoint Farm as you would have less problems removing the DB from SQL later.

You'll probably get an error message after you click remove, since the server isn't able to render the page anymore.

2. Remove Databases

Content DB, Config, Search, SSP, Etc.

3. Remove Web Applications

Use the IIS Management Console, remove all web applications related to the MOSS site.

4. Rename the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12 to 12_OLD

Now you can remove MOSS via add/remove programs.

Administering SQL Server 2005 Internal Database

2009-09-11T14:37:00.001-04:00

Problem

Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-fledged DBAs, how do they manage the Windows Internal Database?

Solution

The Windows Internal Database is an embedded data service that can only be used by a handful of Windows Services. It is designed in such a way that you are not allowed to connect to and use this particular database service for non-Microsoft products. By default, installing either WSUS 3.0 or WSS 3.0 will create the databases on the C:\ partition and will cause administration issues such as insufficient disk space. It is quite confusing to manage this SQL Server instance as it does not appear as a SQL Server service nor are there management tools included with the products. The easiest way is to use SQL Server Management Studio Express. You can install a copy of SQL Server Management Studio Express on the server running your WSUS 3.0 or WSS 3.0. You then register this instance using Named Pipes as this is the only configuration for connectivity. Use this server name when you register this instance

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Once you've managed to register this instance in SQL Server Management Studio Express, you can now administer the WSUS 3.0 and WSS 3.0 databases like shrinking the database files or moving them to a different disk partition dedicated for them to avoid insufficient disk space issues.

If you prefer to use scripts to manage these databases, you can download and install the SQL Server 2005 Command Line Query Utility - sqlcmd . This tool will be installed, by default, on this directory

C:\Program Files\Microsoft SQL Server\90\Tools\binn

To connect to the database instance, you need to run the sqlcmd.exe utility, passing the instance name and your credentials

sqlcmd -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query –E

You can then run your administrative T-SQL scripts once connected to this database instance.

Considerations

While these are possible reasons to administer the Windows Internal Database, it is not recommended to do anything beyond performing backups, moving or shrinking the database files. Modifying database schema or database properties would break supportability of these products. Plus, any changes made to these databases can be overwritten by the products' service packs or cumulative updates.

Next Steps

Install SQL Server Management Studio Express on your WSUS 3.0 and WSS 3.0 servers
Take control of your WSUS 3.0 and WSS 3.0 databases

Finding SQL Server 2005 versions

2009-09-11T14:17:00.001-04:00

How to determine which version of SQL Server 2005 is running

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

The product version (for example, 9.00.1399.06)
The product level (for example, RTM)
The edition (for example, Enterprise Edition)

For example, the results resemble the following.

Collapse this tableExpand this table

9.00.1399.06

RTM

Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release	Sqlservr.exe
RTM	2005.90.1399
SQL Server 2005 Service Pack 1	2005.90.2047
SQL Server 2005 Service Pack 2	2005.90.3042
SQL Server 2005 Service Pack 3	2005.90.4035

Service Packs for Project Server and Office Servers

2009-09-11T12:33:00.003-04:00

You can find: SP1, IU, Aug CU, Oct CU, Dec CU, Mar CU, SP2, Apr CU download and KB information below.

SP 1

Overview and What's Included in SP1

For a description of SP1, please refer to the following knowledge base articles on http://support.microsoft.com/ :

936984 Description of the 2007 Microsoft Office servers Service Pack 1 and the 2007 Microsoft Office servers Language Pack Service Pack 1
936988 Description of the Microsoft Windows SharePoint Services 3.0 Service Pack 1
937154 Description of the Microsoft Office Project 2007 Service Pack 1
937961 Description of the Office 2003 Web Components Service Pack 1 for the 2007 Microsoft Office System

For a list of issues fixed in SP1, please refer to the following knowledge base articles on http://support.microsoft.com/http://support.microsoft.com/ :

942386 Issues fixed in Project 2007 by 2007 Office suite Service Pack 1
942387 Issues fixed in Project Server 2007 by Office 2007 Servers Service Pack 1
942388 Issues fixed in Windows SharePoint Services 3.0 by Windows SharePoint Services 3.0 Service Pack 1
942390 Issues fixed in Office SharePoint Server 2007 by 2007 Office System servers Service Pack 1
942722 Issues Fixed in Microsoft Project Portfolio 2007 Service Pack 1

Critical Planning and Deployment & Installation Information

Next before installing read the following documents which will help you understand the deployment procedure as well as tips tricks and troubleshooting steps:

How to obtain and install SP1?

Patches for all products are available on http://www.update.microsoft.com/Microsoft Update (recommended), http://www.officeupdate.microsoft.comOffice Update and the http://www.microsoft.com/downloadsDownload Center with a few exceptions. Windows SharePoint Services and the WSS Language Packs are live on http://www.update.microsoft.com/windowsupdateWindows Update and Microsoft Update. For those customers with low bandwidth, CDs will be available for order after January 15^th for a small shipping and handling fee from a link off the Download Details page.

For additional information on each release, please see the download details page, in English, for:

______________________________________________________________________________________________________________

Infrastructure Update

Installation Instructions

It is strongly recommended that you:

Install Windows SharePoint Services 3.0 Service Pack 1 and Office Servers Service Pack 1 before installing the Infrastructure Update for Microsoft Office Servers (KB951297) and the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695).

The installation process will incur server and farm downtime that you will need to plan for - the updates should be installed on all servers in a farm.

Deploy Software Updates for Windows SharePoint Services 3.0
Deploy Software Updates for Office SharePoint Server 2007 - This article also applies to Project Server 2007, SharePoint Server 2007, Search Server 2008 and Search Server 2008 Express.
Install the Infrastructure Update for Microsoft Office Servers (Office SharePoint Server 2007)
Install the Infrastructure Update for Microsoft Office Servers (Search Server 2008)

Downloads

	x64	x86
Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)	http://www.microsoft.com/downloads/details.aspx?FamilyId=3A74E566-CB4A-4DB9-851C-E3FBBE5E6D6E&displaylang=en	http://www.microsoft.com/downloads/details.aspx?FamilyId=256CE3C3-6A42-4953-8E1B-E0BF27FD465B&displaylang=en
Infrastructure Update for Microsoft Office Servers (KB951297)	http://www.microsoft.com/downloads/details.aspx?FamilyId=6E4F31AB-AF25-47DF-9BF1-423E248FA6FC&displaylang=en	http://www.microsoft.com/downloads/details.aspx?FamilyId=3811C371-0E83-47C8-976B-0B7F26A3B3C4&displaylang=en
Infrastructure Update for Microsoft Office Project 2007 (KB951547)		http://www.microsoft.com/downloads/details.aspx?FamilyId=F385ADB8-0425-4BA4-BECE-7664B8F49D12&displaylang=en

August Cumulative Update

Installation Order

Assuming you are running the released version of Project Server 2007, here is a high level procedure, please refer to the TechNet articles for detailed deployment steps:

Step	Related Links
1. Deploy Service Pack 1	Announcing the release of EPM 2007 Service Pack 1 (includes links to KB, downloads and deployment documentation) Deploy Service Pack 1 for Office Project Server 2007
2. Deploy the Infrastructure Update (IU). We recommend deploying the IU first because you will get all the latest updates for WSS and SharePoint Server.	Announcing the availability of the Project and Project Server 2007 Infrastructure Update Microsoft Project Infrastructure Update Webcast Slides Deploy the Infrastructure Update for Office Project Server 2007 Install the Infrastructure Update for Microsoft Office Servers (Office SharePoint Server 2007)
3. Deploy the August Cumulative Update. Since the August CU are individually package (one EXE for Project Server and another one for SharePoint Server for instance), then you will have to deploy each one depending on the hotfix required. 4. Run hotfix EXE 5. Run PSCONFIG on each server within your farm to finalize the update 6. Verify Installation by verifying the version of each of the four PS database using the following command: SELECT * FROM VERSIONS Result should be: 12.0.6327.5000	See links below

Update	KB article ID	Article link	Download Link
Cumulative update packages for August 2008 for the 2007 Microsoft Office core suite applications and 2007 Microsoft Office servers	957022	http://support.microsoft.com/kb/957022
Description of the Project 2007 hotfix package: August 26, 2008	956060	http://support.microsoft.com/kb/956060	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=956060
Description of the Project Server 2007 hotfix package: August 26, 2008	956061	http://support.microsoft.com/kb/956061	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=956061
Description of the Windows SharePoint Services 3.0 hotfix package: August 26, 2008	957109	http://support.microsoft.com/kb/957109	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=956057
Description of the SharePoint Server 2007 hotfix package: August 26, 2008	956056	http://support.microsoft.com/kb/956056	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=956056

Announcing the release of the October Cumulative Update

Announcing the release of the August Cumulative Update for Project and Project Server 2007

Deployment guide: http://technet.microsoft.com/en-us/library/dd239177.aspxDeploy cumulative updates (Project Server 2007)

Knowledge Base Articles and Downloads

Title	ID	KB URL	Download URL
Cumulative update packages for the 2007 Microsoft Office core suite applications and for 2007 Microsoft Office servers: October 28, 2008	958847	http://support.microsoft.com/kb/958847
Description of the Project 2007 hotfix package (Project.msp): October 28, 2008	958138	http://support.microsoft.com/kb/958138	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=958138
Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): October 28, 2008	957696	http://support.microsoft.com/kb/957696	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957696
Description of the Windows SharePoint Services 3.0 hotfix package: October 28, 2008	957691	http://support.microsoft.com/kb/957691 (not published yet)	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957691
Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): October 28, 2008	957693	http://support.microsoft.com/kb/957693	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957693

Announcing the release of the December Cumulative Update

Name	KB ID	KB URL	Download Link
Description of the Project 2007 hotfix package (Project.msp): December 16, 2008	959643	http://support.microsoft.com/kb/959643	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959643
Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): December 16, 2008	960313	http://support.microsoft.com/kb/960313	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=960313
Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): December 16, 2008	959644	http://support.microsoft.com/kb/959644	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959644
Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 16, 2008	959637	http://support.microsoft.com/kb/959637	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959637

"October Cumulative Update" (fixes) available for Project and Project Server

Cumulative update packages for the 2007 Microsoft Office core suite applications and for 2007 Microsoft Office servers: October 28, 2008

KB: 958847: http://support.microsoft.com/kb/958847

Description of the Project 2007 hotfix package (Project.msp): October 28, 2008

KB: 958138 http://support.microsoft.com/kb/958138

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=958138Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): October 28, 2008

KB: 957696: http://support.microsoft.com/kb/957696

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957696

Description of the Windows SharePoint Services 3.0 hotfix package: October 28, 2008

KB: 957691: http://support.microsoft.com/kb/957691

(not published yet)

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957691

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): October 28, 2008

KB: 957693 http://support.microsoft.com/kb/957693

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957693

Project Server Service Pack 1: Dec 11, 2007

http://www.microsoft.com/downloads/details.aspx?FamilyId=AD59175C-AD6A-4027-8C2F-DB25322F791B&displaylang=en

December 2008 Cumulative Fixes

Description of the Project 2007 hotfix package (Project.msp): December 16, 2008 / KB: 959643

http://support.microsoft.com/kb/959643

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959643

Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): December 16, 2008 / KB: 960313

http://support.microsoft.com/kb/960313

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=960313

Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): December 16, 2008 / KB: 959644

http://support.microsoft.com/kb/959644

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959644

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 16, 2008 / KB: 959637

http://support.microsoft.com/kb/959637

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=959637

Related links:

* Announcing the release of the October Cumulative Update for Project and Project Server 2007

<http://blogs.msdn.com/chrisfie/archive/2008/10/29/announcing-the-release-of-the-october-cumulative-update-for-project-and-project-server-2007.aspx>

* Announcing the release of the August Cumulative Update for Project and Project Server 2007

<http://blogs.msdn.com/chrisfie/archive/2008/09/26/announcing-the-release-of-the-august-cumulative-update-for-project-and-project-server-2007.aspx>

* Upcoming Microsoft Project 2007 and Project Server 2007 Service Pack 2

<http://blogs.msdn.com/chrisfie/archive/2008/10/25/upcoming-microsoft-project-2007-and-project-server-2007-service-pack-2.aspx>

* Cumulative updates are available from the Microsoft Office team to deliver hotfixes for reported problems

<http://support.microsoft.com/kb/953878>

* Project Server TechCenter

<http://technet.microsoft.com/en-us/office/projectserver/default.aspx> (TechNet)

March 2009 Cumulative Fixes

Guidance on loading Project Server 2007 Cumulative Hotfixes

Description of March 2009 Project Server Hotfixes

Download March 2009 Project Server Hotfixes

Description of the Windows SharePoint Services 3.0 cumulative update package: February 24, 2009

Description of the SharePoint Server 2007 cumulative update package (MOSS server-package): February 24, 2009

Download of the SharePoint Server 2007 cumulative update package (MOSS server-package): February 24, 2009

Service Pack 2 (April, 2009)

Service Pack 2 (SP2) Description
Description of Office Project 2007 Service Pack 2 and Office Project Language Pack 2007 Service Pack 2	953326	http://support.microsoft.com/kb/953326
Description of Windows SharePoint Services 3.0 Service Pack 2 and of Windows SharePoint Services 3.0 Language Pack Service Pack 2	953338	http://support.microsoft.com/kb/953338
Description of the 2007 Microsoft Office servers Service Pack 2 and the 2007 Microsoft Office servers Language Pack Service Pack 2	953334	http://support.microsoft.com/kb/953334

Service Pack 2 (SP2) Download Center Page
Office Project 2007 (x86)	http://www.microsoft.com/downloads/details.aspx?FamilyId=C126FA4A-B43F-4F7E-A9D4-522E92A6CFEE
Office Project Language Pack	http://www.microsoft.com/downloads/details.aspx?FamilyId=B7DF323E-73B8-4344-826A-A01E6F920B1B
WSS (both x86 and x64)	http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en
WSS Language Pack (x86)	http://www.microsoft.com/downloads/details.aspx?FamilyId=085E5AC8-58F6-4CF9-8012-33B95EE36C0F&displaylang=en
WSS Language Pack (x64)	http://www.microsoft.com/downloads/details.aspx?FamilyId=2C2B6CAF-B46D-45EB-AC4D-DEAAA48C3A2C&displaylang=en
Office Servers (x86 and x64)(contains Project Server SP2)	http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082&displaylang=en
Office Servers Language Pack (x86)	http://www.microsoft.com/downloads/details.aspx?FamilyId=01C6A3E8-E110-4956-903A-AD16284BF223&displaylang=en
Office Servers Language Pack (x64)	http://www.microsoft.com/downloads/details.aspx?FamilyId=66C5026F-9F47-4642-8378-2526918009FA&displaylang=en

Service Pack 2 (SP2) Deployment Resources
Deploy Service Pack 2 for Office Project Server 2007	http://technet.microsoft.com/en-us/library/dd637740.aspx
Deploy Project Server 2007 updates	http://technet.microsoft.com/en-us/library/dd630752.aspx
Deploy software updates for Windows SharePoint Services 3.0	http://technet.microsoft.com/en-us/library/cc288269.aspx
Deploy software updates for Office SharePoint Server 2007	http://technet.microsoft.com/en-us/library/cc263467.aspx
Create an installation source that includes software updates (Windows SharePoint Services 3.0)	http://technet.microsoft.com/en-us/library/cc287882.aspx
Create an installation source that includes software updates (Office SharePoint Server 2007)	http://technet.microsoft.com/en-us/library/cc261890.aspx

Service Pack 2 (SP2) Related Technical Resources
Issues Fixed by Service Pack 2 (SP2) in the 2007 Office Desktop Applications (Excel 2007 format)	http://download.microsoft.com/download/C/2/C/C2C36159-600C-4EEA-B80A-F988EE7A418F/2007%20Office%20Service%20Pack%202%20Changes.xlsx
Customers can also go to this KB article for a full list of downloads for Office System 2007 SP2.	http://support.microsoft.com/kb/968170
Service Pack 2 for SharePoint Products and Technologies (whitepaper)	http://go.microsoft.com/fwlink/?LinkId=148374
Issues Fixed by Service Pack 2 (SP2) in Windows SharePoint Services 3.0 (Excel 2007 format)	http://download.microsoft.com/download/7/A/3/7A3E2E01-5454-4427-95CB-28CE84523B0A/Windows%20SharePoint%20Services%203.0%20Service%20Pack%202%20Changes.xlsx
Issues Fixed by Service Pack 2 (SP2) in the 2007 Office Server Products	http://download.microsoft.com/download/4/1/F/41F3A698-55E8-40B4-A306-AD6CF1F95394/2007%20Office%20Servers%20Service%20Pack%202%20Changes.xlsx
Updates Resource Center for SharePoint Products and Technologies	http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx

Project Service Pack 2 High Level Benefits

Project Standard and Project Professional

The scheduling engine, Active Cache, and Gantt charts all have improvements.
There is additional reliability with earlier versions of the .mpp format.

Project Server

Better memory management in the queue service.
Performance to certain database table indexes is improved.
Resource plans, build team, cost resources, and the server scheduling engine have improved.

Once your farm has been properly updated the new SP2 product version will be: 12.0.6422.1000 (please refer to the TechNet deployment article for instructions on how to verify an installation).

Getting Ready for Project Server 2010

As part of the SP2 release Microsoft announced the following requirements for the next release of SharePoint and Project Server: Windows Server 2008 and 64 bit.

Microsoft will be publishing guidance on how to upgrade your existing Project Server 2007 farm to Windows Server 2008 64 bit in the coming weeks on TechNet.

Expect full system requirements for Project Server 2010 at a later date.

Microsoft expects to release a Service Pack 2 for Project Portfolio Server 2007 by June 2009

April 2009 Cumulative Fixes

Please refer to this TechNet article for deployment guidance: Deploy cumulative updates (Project Server 2007)

After applying the April CU, the database version should be: 12.0.6504.5000 (see article above for instructions on how to verify the installation).

Please refer to this post from the Office Sustain Engineering team for more information about SP2 and the April CU: FAQ concerning Service Pack 2 and the Cumulative Updates for April 2009 for the 2007 Microsoft® Office System and Microsoft Office servers

Knowledge Base Articles and Downloads

Title	ID	KB Url	Download URL
Description of the Project 2007 hotfix package (Project.msp): April 30, 2009	969409	http://support.microsoft.com/kb/969409	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=969409
Description of the Project Server 2007 hotfix package (Pjsrvapp.msp, Pjsrvwfe.msp): April 30, 2009	968860	http://support.microsoft.com/kb/968860	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968860
Description of the Windows SharePoint Services 3.0 cumulative update package: April 30, 2009	968850	http://support.microsoft.com/kb/968850	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968850
Description of the SharePoint Server 2007 cumulative update package (MOSS server-package): April 30, 2009	968859	http://support.microsoft.com/kb/968859	http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=968859

Related links:

Deploy cumulative updates (Project Server 2007)	http://technet.microsoft.com/en-us/library/dd239177.aspx
Checklist for deploying Project Server 2007 updates	http://technet.microsoft.com/en-us/library/dd630729.aspx

Project Portfolio Server 2007 SP2

If you are using Project Portfolio Server 2007, then you'll be happy to hear that Service Pack 2 is now available.

Key new features:

Support for SQL 2008
Support for Portfolio Server on Windows Server 2008 Hyper-V

Plus:

Over 40 fixes which are described here: http://support.microsoft.com/kb/971363

Go to the

Project Portfolio Server 2007 SP2 download page to access the service pack. If you have trouble with that page, get the download directly from here
here.

A description of the service pack can be found at: http://support.microsoft.com/kb/971205

Important Note about Service Pack 2May 27, 2009Before you install SharePoint Server 2007 Service Pack 2 (SP2), read important information about SP2 in the SharePoint Team Blog.

For detailed information about these hotfixes and improvements, see KB 970946.

June Cumulative Update (CU) for Windows SharePoint Services 3.0Released June 30, 2009The June CU includes hotfixes and improvements for Windows SharePoint Services 3.0 (KB 971538).

June Cumulative Update (CU) for Office SharePoint Server 2007Released July 15, 2009The June CU includes hotfixes and improvements for Office SharePoint Server 2007. For detailed information about these hotfixes and improvements, see KB 971537.

August Cumulative Update (CU) for Windows SharePoint Services 3.0Released August 25, 2009The August CU includes hotfixes and improvements for Windows SharePoint Services 3.0. For detailed information about this update, see KB 973400.

August Cumulative Update (CU) for Office SharePoint Server 2007Released September 9, 2009The August CU includes hotfixes and improvements for Office SharePoint Server 2007. For detailed information about this update, see KB 973399.

Important Note about August Cumulative Update (CU)September 16, 2009There is a known issue with installing the August CU for Windows SharePoint Services 3.0 on Windows SharePoint Services 3.0 or Office SharePoint Server 2007 farms. This relates to detaching content databases when installing the CU. For more information, see the following blog posts:

http://blogs.technet.com/stefan_gossner/archive/2009/09/14/important-be-careful-when-installing-wss-august-cumulative-update.aspx

http://blogs.msdn.com/joerg_sinemus/archive/2009/09/11/wss-august-cu-and-re-attached-content-databases.aspx

Hope this is useful –

Gokul Rajan

Project Server Services arent starting

2009-04-23T00:03:00.000-04:00

There would be instances where Project Server services might not be running or is not starting when started manually:

There are couple of work around and hot-fixes to this issue:

Option A:

WORKAROUND/RESOLUTION:
===========================
1. Run "C:\Program Files\Common Files\Microsoft Shared\Web Server
Extensions\12\bin\psconfig -cmd upgrade -inplace b2b -wait -force".
2. In registry editor add/modify the following values on
"HKLM\System\CurrentControlSet\Control":
a) ServicesPipeTimeout DWORD 60000 (decimal).
b) WaitToKillServiceTimeout changed to "120000".
3. Reboot the server

Option B:

Error 1053 appears after trying to start the event and queue service

After installing Project Server and Office Server 2007 SP1, starting the
Project Event and Project Queue services times out with the following error:
Error 1053: The service did not respond to the start or control request in
a timely fashion.
The solution:
1. Download certificate revocation files from
http://crl.microsoft.com/pki/crl/products/CodeSignPCA.crl
and
http://crl.microsoft.com/pki/crl/products/CodeSignPCA2.crl
2. Copy the files into the same folder as the service .exe files:
C:\Program Files\Microsoft Office Servers\12.0\Bin
3. Open a command prompt at the above referenced location:
certutil -addstore CA CodeSignPCA.crl
certutil -addstore CA CodeSignPCA2.crl
4. Start the services either from the services applet or from the command
prompt (net start).

Option C:

1. Make sure that the SSP administrator account is simillar to the account reflected on the Project Server Services.
2. Re-run the services using adminstrative account that was used to install Project Server
3. If the server is not running with either of 1 or 2 steps, temporarily enable the internet connection (Enable HTTP) and restart the system.

Understanding Migration to Project Server 2007

2009-04-19T18:07:00.000-04:00

Understanding Migration plans in Project Server 2007

If you have presented EPM solutions to your clients/companies, the first question you think is if they have current working copy of a project server/methodology ? And if they do, what version are they running and if they are fully equipped to unleash the potential of existing process/procedures within.

These and many more questions sprout thoughts that arise, awake and enlighten not only your clients but your own curiosity of the direction in which the current negotiations is driving towards. In one such occurrence, I always felt that when client discusses about moving to a newer version of their well oiled project solution that I felt short-handed to come to a tailor made solution of migration.

There are lots of questions related to migration that are so critical, the sense of direction is slightly blurred to many current Project Server 2003 administrators. I have put few links where you could find decent materials for Project Server 2007 Migration but always know that the document you may find online is a reference and needs to be fine tuned based on your clients/company's requirements.

Migration of Project Server 2007 ebook

This book covers migrating data from previous versions of Project Server (Project Server 2003, Project Server 2002, Project Central) to Microsoft Office Project Server 2007. The audiences for this book are business application specialists, line-of-business specialists, IT generalists, program managers, and infrastructure specialists who are deploying a solution based on Office Project Server 2007 with SP2.

FAQ on Migration

This article answers frequently asked questions about upgrading previous versions of Microsoft Project Server to Microsoft Office Project Server 2007 such as:

1. Compatibility Questions
2. Consolidation Questions
3. Pricing & Licensing
4. Data Consistency
5. Architecture
6. Data Management
7. WSS Migration questions

Hope this helps - More in the next blog -