Service Pack 2 for Office Sharepoint Server 2007 and Windows Sharepoint Services 3.0 has been released

 

Installation Steps

To keep all the files in a SharePoint installation up-to-date, the following packages need to be applied on all servers in the farm. Service Pack 2 contains all fixes released through February of this year, so customers can install it directly on RTM build of the products.

1. Service Pack 2 for Windows SharePoint Services 3.0
2. Service Pack 2 for Windows SharePoint Services 3.0 Language Pack (if applicable)
3. Service Pack 2 for Office SharePoint Server 2007
4. Service Pack 2 for Office SharePoint Server 2007 Language Pack (if applicable)

After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or "psconfig –cmd upgrade –inplace b2b -wait” in command line. This needs to be done on every server in the farm with SharePoint installed.  The version of content databases should be 12.0.0.6425 after successfully applying these updates.

 

 

Overview of Service Pack 2 (SP2) improvements (Office servers 2007)

Microsoft Enterprise Content Management (ECM)

• Improves the performance and stability of the content deployment feature and of the Variations feature.
• Adds a new command to the Stsadm.exe tool. This tool provides the following functionality:
  • Lets a SharePoint administrator use the Variations feature to scan a site for errors, report the errors, and fix certain problems.
  • Finds and repairs missing peer relationships and corrupted entries in the internal variations relationships list.
  • Handles the propagation of large volumes of variations content in a more manageable way.

Microsoft Office Excel and Microsoft Office Access services

• Fixes Open Snapshot so that snapshots open more reliably, even if there is no SharePoint root site.
• Fixes display issues that cause calculations to appear incorrect in some cases.
• Improves connections to cubes by using .odc files in non-English cases.
• Improves the performance of programmatic scenarios.
• Fixes conditional formatting in Mozilla Firefox browsers.
• Improves support for generating Excel Web Access Web parts on new sites.

Microsoft Office Groove Server (64-bit version only)

• Office Groove Server 2007 Data Bridge now limits the number of file-sharing workspaces to 64 to make sure that all workspaces can be synchronized. This limit applies only to newly added file-sharing workspaces. If you already have more than 64 file-sharing workspaces, you can continue to use them.
• Improves synchronization reliability.
• Groove Server 2007 Manager can be installed and run with SQL Server 2008.
• Improves the Groove Lightweight Directory Access Protocol (LDAP) connectivity and auto-activation functionality.
• Improves error reporting in the Groove Relay Server.
• Improves the robustness of Groove Relay Server.

Microsoft Office Forms Server

• Improves performance of large browser forms on InfoPath Form Services, both for memory usage and for page load time.
• Improves reliability of Forms Server and of Microsoft Office SharePoint Server by addressing the previous behavior in which an upgrade of an administrator-approved form template triggers an IIS reset.
• Improves the Digital Signature functionality for InfoPath Forms Services.

Microsoft Office Project Server

• Modifies the queue service to prevent it from using large volumes of memory over long periods.
• Improves the performance of certain database table indexes.
• Improves cost resource functionality. For example, the server now correctly handles tasks that have material or work resources assigned to the same task.
• Improves certain areas such as resource plans, build team, and the server scheduling engine.

Microsoft Office Search Server

• Improves the reliability and stability of WSS crawl, of SharePoint crawl, of crawling through a very large corpus, and of backup restore.
• Introduces a new command to the Stsadm.exe tool that lets a SharePoint administrator tune the Query processor multiplier parameter. For example, the Query processor multiplier can be used to tune the query performance for SSP indexing content sources that have highly restrictive permissions and many duplicates.
• Improves the accuracy of searches that involve numbers. For example, there is additional support for large numbers in which a comma is used to separate every three digits (for example, 1,000,000), for numbers that are between 9 and 40 characters, and for numbers that are separated by spaces.

Platform support

• Provides full support for Windows Internet Explorer 8.
• Provides level 2 browser support for Mozilla Firefox (versions 2 and 3).
  • For more information about browser support levels, visit the following Microsoft Web site:

    http://office.microsoft.com/en-us/sharepointserver/HA101945391033.aspx (http://office.microsoft.com/en-us/sharepointserver/HA101945391033.aspx)

• Provides support for Windows Server 2008.

How to obtain and install the service packs

This service pack update is available on the Microsoft Download Center. To download the service pack, visit the following Microsoft Web sites:

• 2007 Microsoft Office servers Service Pack 2 (x86)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082 (http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082)

 

• 2007 Microsoft Office servers Service Pack 2 (x64)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082 (http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082)

 

• 2007 Microsoft Office servers Language Pack Service Pack 2 (x86)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=01C6A3E8-E110-4956-903A-AD16284BF223 (http://www.microsoft.com/downloads/details.aspx?FamilyId=01C6A3E8-E110-4956-903A-AD16284BF223)

 

• 2007 Microsoft Office servers Language Pack Service Pack 2 (x64)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=66C5026F-9F47-4642-8378-2526918009FA (http://www.microsoft.com/downloads/details.aspx?FamilyId=66C5026F-9F47-4642-8378-2526918009FA)

 

Overview of Service Pack 2 improvements (Windows Sharepoint Services 3.0)

 

Some big areas of the improvements that the Windows SharePoint Services team wanted to highlight:

• Faster, more reliable content migration and data backup and restore
• Reduced memory consumption
• Smoother upgrade experience
• Significant database performance adjustments
• Updated integration for forms authentication
• Advanced permission management
• Helpful administrative tools
• Expanded browser compatibility

How to obtain and install the service packs

This service pack update is available on the Microsoft Download Center. To download the service pack, visit the following Microsoft Web sites:

• Windows SharePoint Services 3.0 Service Pack 2 (x86)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B (http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B)

 

• Windows SharePoint Services 3.0 Service Pack 2 (x64)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B (http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B)

 

• Windows SharePoint Services 3.0 Language Pack Service Pack 2 (x86)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=085E5AC8-58F6-4CF9-8012-33B95EE36C0F (http://www.microsoft.com/downloads/details.aspx?FamilyId=085E5AC8-58F6-4CF9-8012-33B95EE36C0F)

 

• Windows SharePoint Services 3.0 Language Pack Service Pack 2 (x64)

  http://www.microsoft.com/downloads/details.aspx?FamilyId=2C2B6CAF-B46D-45EB-AC4D-DEAAA48C3A2C (http://www.microsoft.com/downloads/details.aspx?FamilyId=2C2B6CAF-B46D-45EB-AC4D-DEAAA48C3A2C)