HP Web Jetadmin Software Microsoft SQL Database Overview, 1HP Web Jetadmin Directories and Files

C:\Program Files\Microsoft SQL Server\MSSQL.10.HPWJA\MSSQL\Binn\sqlserver.exe

Display name: SQL Server (HPWJA)

The following table provides a list of the files that are typically found in the directories.

Table 2-1HP Web Jetadmin Directories and Files

Directory	Files
C:\Program Files	●	Core application components, DLLs, and more
	●	HP Web Jetadmin service executable
	●	Files downloaded through Smart Client application install
	●	Universal Print Driver
	●	Certificates
	●	End User License Agreements (EULAs)
	●	Other documents such as the release notes and online user
		documentation.
C:\Windows\ServiceProfiles\NetworkService\AppData\Local	●	All application settings (file-based)
\Hewlett-Packard\HPWebJetadmin	●	Trace control file for debug mode
	●	Trace file when debug mode (server) is enabled

You can back up and restore the user settings and data that are stored in the HP Web Jetadmin database. For more information, see Back Up and Restore HP Web Jetadmin on page 21. The user settings and data that are not stored in the HP Web Jetadmin database are stored in files that are available in the following directory:

C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Hewlett-Packard\HPWebJetadmin

Microsoft SQL Database Overview

HP Web Jetadmin uses a Microsoft SQL database instance to store and manage the captured device data. Microsoft SQL Server Express Edition is embedded in HP Web Jetadmin. Microsoft SQL Server Express Edition requires .NET Framework, has a 4 GB limitation on the size of the database, and can exist on a host with any other Microsoft SQL Server implementation.

If Microsoft SQL Server 2005 Express Edition is not already installed, HP Web Jetadmin installs it during the initial application installation. HP Web Jetadmin can coexist with other versions of Microsoft SQL Server if they are installed on the same host.

During the installation, HP Web Jetadmin executes OSQL commands that install the database components, including the HP Web Jetadmin database instance and data structures. There are no user-specified attributes for any of the SQL elements during the installation.

HP Web Jetadmin creates a named Microsoft SQL Server Express Edition database instance during the installation. The database instance is a service that runs in Windows Service Manager MMC and has a dependency on the HP Web Jetadmin service (HPWJA Service). You can also observe the HPWJA Service in Windows Service Manager MMC. You must stop the HPWJA Service before you can stop the Microsoft SQL service.

HP Web Jetadmin manages the proprietary HP Web Jetadmin database. HP Web Jetadmin must be the only entity that connects to the database. The database does not contain user-accessible details and cannot be used as a source of raw content for other user processes.

The HP Web Jetadmin database contains the following data:

ENWW The HP Web Jetadmin Server 33