
OVERVIEW
By default HP Web Jetadmin uses Microsoft
®
SQL Server 2008 Express or SQL Server 2012 SP2
Express. This white paper explains when SQL Server 2012 SP2 Express is used and how SQL Server
2008 Express can be upgraded to SQL Server 2012 SP2 Express for HP Web Jetadmin.
VERSIONS OF SQL SERVER EXPRESS THAT HP WEB
JETADMIN USES (AFTER A DEFAULT INSTALLATION)
HP Web Jetadmin 10.3 SR8 uses SQL Server 2008 Express or SQL Server 2012 SP2 Express
depending on whether it is a new installation or an upgrade from an older version. New installations
of HP Web Jetadmin 10.3 SR8 and later use SQL Server 2012 Express SP2. Older installations of
HP Web Jetadmin or installations that were upgraded from 10.3 SR7 and earlier to 10.3 SR8 and
later continue to use SQL Server 2008 Express.
DETERMINE WHICH VERSION OF SQL SERVER EXPRESS IS
INSTALLED
There are several methods to determine which version of SQL Server Express is installed.
Method 1—Add/Remove Programs
The product version is displayed in Add/Remove Programs.
The following table provides an overview of the relevant releases and product versions.
Release Product version
SQL Server 2008 SP3 Express 10.00.5500.00
SQL Server 2008 SP2 Express 10.00.4000.00
SQL Server 2008 SP1 Express 10.00.2531.00
SQL Server 2008 Express RTM 10.00.1600.22
SQL Server 2012 SP2 Express 11.0.5058.0
SQL Server 2012 SP1 Express 11.00.3000.00
SQL Server 2012 Express RTM 11.00.2100.60
However, different versions of SQL Server Express might be listed in Add/Remove Programs. For
example, if Microsoft SQL Server Management Studio is installed, another method must be used to
find the product version.
Method 2—Error logs
Look at the first few lines of any ERRORLOG.n file for the HPWJA instance. The error logs are
available in a location similar to one of the following:
• C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log
• C:\Program Files\Microsoft SQL Server\MSSQL11.HPWJA\MSSQL\Log
The version is listed in the first line of all the ERRORLOG.n files.
Commenti su questo manuale