
OVERVIEW
HP Web Jetadmin 10.x automatically installs and uses a database that runs under Microsoft SQL
Express. However, it might be more convenient for HP Web Jetadmin to use a full version of Microsoft
SQL Server to gain performance benefits and avoid the SQL Express 4 GB database limitation (pre
2008 R2). Fortunately, HP Web Jetadmin can be configured to use SQL Server instead of SQL
Express either on the same machine or on a remote machine. This document describes how to create
a named instance on an installation of SQL Server, configure HP Web Jetadmin to use that instance,
and migrate an HP Web Jetadmin database from SQL Express to SQL Server if required.
IMPORTANT For HP Web Jetadmin 10.4 and earlier, the folder name in the installation directory
path is Hewlett Packard. For HP Web Jetadmin 10.4 SR1 and later, the folder name
in the installation directory path has been changed from Hewlett Packard to HP Inc.
INTRODUCTION
Whether you are installing a local or remote SQL Server, the steps to configure an HP Web Jetadmin
installation to use SQL Server are essentially the same.
1. Create a SQL instance.
2. Create a new SQL database.
3. Modify HP Web Jetadmin to point to the new instance and database.
Each HP Web Jetadmin installation must point to its own unique database. HP Web Jetadmin allows
for a connection to SQL Server on the same machine or to a SQL Server instance on a remote
machine.
NOTE Releases of HP Web Jetadmin prior to 10.3 SR3 required the installation of a license to use a
remote SQL database. This restriction has been lifted starting with HP Web Jetadmin 10.3
SR3. Customers are no longer required to obtain the Database Connectivity Module and
install a license to use a remote SQL database. To connect an older version of HP Web
Jetadmin to a remote SQL database, visit www.hp.com/go/webjetadmin for more
information about obtaining a license for the Database Connectivity Module, and then see
Appendix A for instructions on how to install the license.
FIRST TIME INSTALLATION OF HP WEB JETADMIN
As a convenience, HP Web Jetadmin automatically installs SQL Server 2012 Express SP2 because a
SQL database is required to run HP Web Jetadmin. However, you might prefer newer versions of SQL
Server, such as SQL Server 2014. While HP thoroughly tests the SQL Express version that HP Web
Jetadmin automatically installs, you are certainly welcome to use other versions of SQL Server,
including older versions.
For a first time installation of HP Web Jetadmin where you want to use a remote SQL database from
the beginning, the following options are available:
Allow the HP Web Jetadmin installer to install SQL Server Express, and then point the installation
to a remote SQL instance.
Run a command-line installation of HP Web Jetadmin and choose to bypass the SQL Express
installation, and then point the installation to a remote SQL instance. Use the following command
to run the installer from a command line so that it skips the SQL database installation.
WjaSetup.exe /V”WJA_SKIP_DB_INSTALL=1”
The directory of files for HP Web Jetadmin that are created under the NetworkService folder are
incomplete (only a handful of files) until a successful connection is made to a SQL database.
Comentários a estes Manuais