Do More Than Manage
Gord Schmidt's Ideas for Doing More with Microsoft Project Server
Summary Task

Which Service Pack is Installed?

When I am asked to resolve an issue occurring in a Project Server 2003 environment, it is quite handy to know which service pack has been applied to Project Server and to Project Professional. Here are some ways to check.

Project Professional 2003

The Windows client is easy to check. Just check the version in the properties of the Winproj executable.

Service Pack

Winproj.exe Version

No Service Pack

11.0.2003.816

Service Pack 1

11.1.2004.1707

Service Pack 2

11.2.2005.1801

Note that the version number for service pack 2 appears slightly differently if you access it from the Help/About menu instead appear as 11.2.2005.1801.15.

See kb821549 (How to check the version of Office 2003 products) for more information.

Project Server 2003

The service packs for Project Server 2003 come in three distinct components: Server, SharePoint and SQL Server. It is not uncommon to come across installations where only one of the three components of the service pack has actually been installed and this leads to problems.

Checking what service pack has been applied to Project Server 2003 (Server portion) is simple. Simply check the version of the pds.dll.

Service Pack

PDS Version

No Service Pack

11.2003.0816

Service Pack 1

11.2004.0.1707

Service Pack 2

11.2005.0.3801

Service Pack 2a

11.2005.0.4110


Remember, if you have modified one of the PWA Active Server Pages, they may not get updated by the service pack (kb906357).

Project Server 2003: SharePoint Services

Service Pack 2 and Service Pack 2a simply reapplied the SharePoint changes that were in Service Pack 1. To check if Service Pack 1 (or any following service packs) has been applied to Project Server's SharePoint portion, check the Date Modified of the PWAISSUE.JS file under:
\Common Files\Microsoft Shared\web server extensions\60\template\layouts\1033\pwainc

The Service Pack 1 Date Modified is March 25, 2004 whereas the original installation of the file would be August 16, 2003.

Project Server 2003: SQL Server

You can check what Project Server service pack has been applied to the Project Server database by examining the MSP_WEB_ADMIN table and looking at the WADMIN_VERSION_MAJOR and WADMIN_VERSION_MINOR fields.

Service Pack

Major

Minor

No Service Pack

11

0

Service Pack 1

11

1

Service Pack 2

11

2

Service Pack 2a

11

2

As you can see, this particular check does not help you distinguish between Service Pack 2 and Service Pack 2a. Unfortunately, I do not have the SQL scripts for Service Pack 2 so I cannot compare them to 2a to give you a definitive way to tell them apart. If anyone has that information, drop me a line and let me know.

Update: David Gage emailed me with a clever suggestion: "if you are unsure if the SQL update was applied as SP2 or SP2a... simply rerun [SP2a]". He also mentioned the great practice of doing backups before applying a service pack.

Posted by Gord Schmidt on Wednesday, August 23, 2006 | Permalink | Resolve

Milestone