Migrating Monitoring Server data from a test environment

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

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

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

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

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

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: Planning and Deploying Service Pack 1 for Microsoft Office SharePoint Server 2007 in a Multi-server Environment Deploying software updates for Windows SharePoint Services 3.0 Deploy software updates for Office Project Server 2007 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 15th 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: Project (Project client only!) Project Language Pack Servers (MOSS, Project, Forms, Groove) (Project Server) Server Language Packs, x86 Server Language Packs, x64 Windows SharePoint Services Windows SharePoint Services Language Pack Windows SharePoint Services Language Pack, x64 Windows SharePoint Services with SP1 (slipstream) Windows SharePoint Services with SP1, x64 (slipstream) ______________________________________________________________________________________________________________ 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 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