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

Cut and paste the contents of the example shown above into the configuration file, replacing

“HPWJA_FULL” with the name of the named instance.

If SQL Authentication was selected during installation of the instance, add the SQL user credentials

that were given dbo rights on the database to the file as such (Figure 7):

Restart Web Jetadmin Service

Stop and restart the HP Web Jetadmin Service (HPWJA Service) under Administrative Tools, Services.

If a password was entered into the file, it will be encrypted after the service restart for security

purposes.

NOTE The inclusion of a user name and password in this file indicates Web Jetadmin will use SQL

Authentication. The lack of a user name and password will instruct Web Jetadmin to use Integrated

Security (Windows Authentication). When Web Jetadmin and SQL Server are on the same machine,

Web Jetadmin runs under Network Service and expects Network Service to have dbo rights (or

read/write at a minimum) on the database.

If the option to not install a SQL database was used during installation, once Web Jetadmin connects

to the SQL database for the first time, many files a directories will be created in the same area as

where the database.Settings.config.xml file was edited. Launch HP Web Jetadmin to validate that the

new blank database is now in use (All Devices should display zero devices).

<ipmc:configuration xmlns:ipmc="www.hp.com/schemas/imaging/ipmc/config/2004/02/24">