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

Database, and enter the database name to be “HPWJA” (see Figure 5). For SQL Server on the same

machine as HP Web Jetadmin, the database MUST be named “HPWJA”.

If Windows Authentication was selected above, the credentials of the user running the Web Jetadmin

service (Network Service) will need dbo rights on the database. If SQL Authentication was selected,

create a user to have dbo rights on the database and write down the name and password as it will

be used later.

Configuring HP Web Jetadmin to Use the New Database

To configure HP Web Jetadmin to use a new SQL

Server database on a Windows XP or 2003

machine, edit the following file:

DRIVE:\Documents and

Settings\NetworkService\Local

Settings\Application Data\Hewlett-

Packard\HPWebJetadmin\WjaService\

config\DatabaseSettings.config.xml

On Windows Vista/2008 R2/Windows 7

systems:

DRIVE:\Windows\ServiceProfiles\

NetworkService\AppData\Local\Hewlett-

Packard\HPWebJetadmin\WjaService\

config\DatabaseSettings.config.xml

Care must be exercised when editing these XML files as extraneous carriage returns can create

problems. Be careful to ensure carriage returns reside as indicated in the examples below.

Typical symptoms that the file has not been edited correctly include the inability to connect to the

HP Web Jetadmin server after restarting the service (since the server cannot connect to the

database).

NOTE It is imperative to open the existing file and copy/paste the contents as they are displayed

here to maintain the user rights. The file must have read/write rights for Network Service in

order for HP Web Jetadmin to be able to use it. If a new file is created instead of opening the

existing file, the new file assumes the user’s rights. If this happens, HP Web Jetadmin does

not attempt to use the new database and defaults to the old one. Ensure that Network Service

has read/write rights. Some older versions of HP Web Jetadmin may not contain the

DatabaseSettings.config.xml file by default, and it must be created by the user. Just ensure the

rights are assigned as mentioned above when creating the new file. Also, if file extensions

are hidden in Windows Explorer, make sure the file does not have a “.txt” extension or two

“.xml” extensions. This is a common mistake when using a text editor to create this file.

For SQL Server running on the same machine as HP Web Jetadmin, if Windows Authentication Mode

had to be chosen during the SQL installer, and “HPWJA” had to be set as the database name, the

only necessary item in this configuration file is the name of the named instance.

Figure 5—Create new database