How to Determine the Correct ISA Server SE Version and Service Pack Information

How to determine the correct ISA Server 2004 or ISA Server 2006 product version and the installed ISA Server Service Pack. We will also show how to determine the installed version of the MSDE (Microsoft SQL Server Desktop Engine), if used and its installed Service Pack version.
Marc Grote photo

Let’s begin

Someone could ask “Why an article about how to determine the correct ISA Server version and its Service Packs – I already know my ISA Server”. This might be correct if you are the person who installed ISA Server but when you are working in a larger IT department with a larger IT staff and with many ISA Servers, things could be more complicated. So let’s go through the process, it is very easy and only tricky when you use ISA Server 2004.

ISA Server 2004

An Administrator should always see that ISA Server 2004 is installed when he opens the ISA Server Management Console. However, the first look does not tell him which ISA Server Service Pack is installed.

To determine which Service Pack is installed, you can start the ISA Server 2004 Management Console and navigate to the ISA Server object and the console tells us, that ISA Server version 4.0.2161.50 is installed – 4.0.2161.50 is ISA Server 2004 RTM (Release To Manufacturing).


Figure 1:
ISA Server 2004 Product version

But what version will be displayed when you install ISA Server 2004 Service Pack 1 or newer versions? – Not good: After installing a ISA Server 2004 Service Pack, the MMC still displays ISA version 4.0.2161.50!

There must be another way to display the Service Pack version. One method is to navigate in the ISA Server Management Console to HelpAbout ISA Server.


Figure 2:
Correct ISA Server Product version

This will display the correct ISA Server Version with its Service Packs but only if you open the MMC on the ISA Server itself. If you open the Info about ISA Server on a client with the installed ISA Server MMC SnapIn, you will only see the locally installed client version. If the client version does not have the same patch level as the ISA Server, you will see different versions.

One definite way to see the ISA Server version is to open the Control PanelAdd or Remove Programs option and you will see which ISA Server 2004 version and Service Packs is installed as you can see in the following picture.


Figure 3:
ISA Server 2004 Product version and Service Pack in Control Panel

The last possibility to determine the ISA Server patch level is to open the file properties of the wspsrv.exe file. You will find the wspsrv.exe file in the ISA Server program installation directory.


Figure 4:
ISA Server 2004 Product version and File version

You can see the Product Name and the version in the first line under File version.

ISA Server 2004 Version numbers

There are a number of different ISA Server versions, so I used the table from www.msisafaq.de to show you the different versions.

4.0.1872.0

14.11.2003

Beta 2

4.0.2076.50

24.02.2004

RC

4.0.2141.50

07.04.2004

RC refresh

4.0.2161.50

13.07.2004

RTM - Final Version

4.0.2163.213

28.02.2005

SP1

4.0.2165.594

01.02.2006

SP2

4.0.2165.610

10.04.2006

SP2 with KB 916106

4.0.2167.887

01.05.2007

SP3

Table 1: ISA Server 2004 Product versions and Service Pack information

ISA 2006

An Administrator should always see that ISA Server 2006 is installed when he opens the ISA Server Management Console, but once again, at first glance you cannot see which ISA Server Service Pack is installed.

To determine,which Service Pack is installed, you can start the ISA Server 2006 Management Console and navigate to the ISA Server object and the console shows us that ISA Server version 5.0.5722.380 is installed – 5.0.5722.380 is the English ISA Server 2006 SP1 Beta.


Figure 5:
ISA Server 2006 - ISA Computer details

ISA Server Computer details


Figure 6:
ISA Server 2006 – Correct Product version

There must be another way to display the Service Pack version. One method is to navigate in the ISA Server Management Console to HelpAbout ISA Server.


Figure 7:
ISA Server 2006 - Product version details

Please note:
The big difference between ISA Server 2004 and ISA Server 2006 is that ISA Server 2006 always displays the correct installed ISA Server Service Pack.

One definite way to see the ISA Server version is to open the Control PanelAdd or Remove Programs option and you will see which ISA Server 2006 version and Service Pack is installed as you can see in the following picture.


Figure 8:
ISA Server 2006 Product version and Service Pack information in Control Panel

One of the other options to determine the ISA Server patch status is to display the file properties of WSPSRV.EXE in Windows Explorer. You can find the file in the ISA Server program directory.


Figure 9:
ISA Server 2006 Product version and File version

You can see the Product Name and the version in the first line under File version.

ISA Server 2006 Version numbers

5.0.5272.100

24.01.2006

Beta 1

5.0.5720.100

25.07.2006

RTM - Final Version

5.0.5720.157

16.01.2007

RTM with Exchange Publishing Update

5.0.5721.240

11.09.2007

RTM with Supportability Update

5.0. 5723.493

03.07.2008

Service Pack 1

Table 2: ISA Server 2006 Product versions and Service Pack information

Determining the Installed MSDE Version

If you installed ISA Server 2006 with advanced logging, ISA Server will be installed with a local MSDE version. You should always install the latest Service Pack version for the MSDE to provide additional security and functionality.

The easiest way to determine the installed SQL/MSDE version is the Additional support information in control panelAdd or Remove Programs.


Figure 10:
MSDE version information

Table of SQL Versions

SQL Server 2008

Katmay November CTP (CTP 5) (November 18, 2007)

10.00.1075.23

Katmay July CTP ( CTP 4) (July 31, 2007)

10.00.1049.14

June 2007 CTP Release (Katmai)

10.00.1019

SQL Server 2005

Cumulative Update Package 3 for SP2 (August 23, 2007)

9.00.3186

Cumulative Update Package 2 for SP2 (June 22, 2007)

9.00.3175

Critical Update SP2 (March 6, 2007)

9.00.3050

SP2 (February 16, 2007)

9.00.3042

SP2 CTP (November 6, 2006)

9.00.3027

Cumulative hotfix package (July 13, 2006)

9.00.2153

SP1 (April 19, 2006)

9.00.2047

RTM (November 7, 2005)

9.00.1399.06

September 2005 CTP Release

9.00.1314

June 2005 CTP Release

9.00.1187

April 2005 CTP Release

9.00.1116

December 2004 CTP Release

9.00.981

Beta 2

9.00.852

Beta 1

9.00.608

SQL Server 2000

SP4

8.00.2039

SP3a

8.00.760

SP3

8.00.760

SP2

8.00.534

SP1

8.00.384

RTM

8.00.194

SQL Server 7.0

SP4

7.00.1063

SP3

7.00.961

SP2

7.00.842

SP1

7.00.699

RTM

7.00.623

SQL Server 6.5

SP5a Update

6.50.479

SP5a

6.50.416

SP5

6.50.415

SP4

6.50.281

SP3

6.50.258

SP2

6.50.240

SP1

6.50.213

RTM

6.50.201

Table 3: SQL version: (Source)

Conclusion

In this article I tried to show you how to determine the installed ISA Server version and the installed ISA Server Service Pack and other patch status. As you have seen, it is very easy to determine the version of your ISA Server. With that understanding it is easy to see if there are additional service packs or patches need for your system. If you are an ISA consultant, you will have a quick overview about the ISA Server patch status at customer side.

About Marc Grote

Marc Grote photo Marc Grote is an MCSA/MCSE Messaging & Security, an MCTS/MCITP and a Microsoft Certified Trainer and MCLC. He is a freelance IT Trainer and Consultant in the north of Germany near Hanover. He works with Invenate GmbH on special projects. You can find more information about Invenate at ttp://www.invenate.de. He specializes in ISA Server, Exchange, Security for Windows 2000/2003 and Windows Server 2008 designs, migrations and implementations, and Citrix Metaframe implementations. His efforts have earned him recognition as a Microsoft MVP for ISA Server since 2004. You can visit his homepage at http://www.it-training-grote.de.

Click here for Marc Grote's section.

Share this article

Receive all the latest articles by email!

Get all articles delivered directly to your mailbox as and when they are released on ISAserver.org! Choose between receiving instant updates with the Real-Time Article Update, or a monthly summary with the Monthly Article Update. Sign up to the ISAserver.org Monthly Newsletter, written by ISA expert Dr. Tom Shinder, containing news, the hottest tips, ISA links of the month and much more. Subscribe today and don't miss a thing!



Receive all the latest articles by email!

Receive Real-Time & Monthly ISAserver.org article updates in your mailbox. Enter your email below!
Click for Real-Time sample & Monthly sample

Become an ISAserver.org member!

Discuss your ISA Server issues with thousands of other ISA Server experts. Click here to join!

Solution Center

Readers' Choice

Which is your preferred ISA Appliance?