HP Web Jetadmin - Using Microsoft SQL Server with HP Web Jetadmin

4
INSTALLSQLDATADIR="DRIVE:\Program Files\Microsoft SQL Server"
INSTALLSQLSHAREDDIR="DRIVE:\Program Files\Microsoft SQL Server"
If the SQL Express installer returns an error,
HP Web Jetadmin posts an error. For example, if
the HPWJA instance is disabled or cannot be
started, an error occurs.
Once HP Web Jetadmin and SQL Server are
successfully installed on the same machine,
perform the following steps to instruct HP Web
Jetadmin to use SQL Server instead of SQL
Express.
Creating a Named SQL Instance
The HP Web Jetadmin installer creates a SQL
Express instance named HPWJA and a database
named HPWJA to store its information. In order to
instruct HP Web Jetadmin to use SQL Server
instead, a named instance and new database
must be created. The default SQL Server instance
is not supported when attempting to use a SQL
Server database on the same machine as
HP Web Jetadmin.
While creating a named instance can be
accomplished in several ways, this document will
discuss running the SQL installer to create the
instance.
Run the SQL Server installer on the machine
where HP Web Jetadmin is running. The installer
will ask to create a default instance or a named
instance (see Figure 2). Use a named instance
(such as HPWJA_FULL). The SQL service can run
under either a built-in system account such as
Network Service (since HP Web Jetadmin runs
under Network Service) or a domain user account
(see Figure 3).
The SQL installer will ask if either Windows
Authentication Mode or SQL Server
Authentication Mode is to be used (see Figure 4).
Select the desired mode.
Creating a New Database
Once the installer has completed and a named
instance has been created, it is time to create a
new database for HP Web Jetadmin to use. To
create a new database, launch the SQL Server
Management Studio and open the named
instance (HPWJA_FULL) that was just created.
Right-click the Databases folder, select New
Figure 2—Create named instance
Figure 3—Run under Network Service
Figure 4—Authentication Mode for same server SQL