HP Device Manager 4.6 - Database Troubleshooting Guide

Overview

The purpose of this document is to give some background on the HPDM database and help customer to troubleshoot the

database-related problems.

HPDM can be used with two types of database: Microsoft® (MS) SQL Server and PostgreSQL. To use MS SQL Server, you

must install and configure it yourself. PostgreSQL is an open-source database that is bundled with the HPDM Server. You do

not need to install or configure it yourself.

Using MS SQL Server

MS SQL Server can be used with one of two authentication types: SQL Server Authentication or Windows Authentication.

Both of these authentication types are supported by HPDM. SQL Server Authentication has an inner security mechanism that

is easy to use. Windows® Authentication needs the Windows operating system security mechanism.

To configure MS SQL Server using Windows Authentication:

1. Log on to a Windows domain account and assign it the minimum privilege dbcreator in Microsoft SQL Server.

2. Open the HP Device Manager Database Setup dialog. Select MS SQL Server under Database Type and select

Windows Authentication under Authentication.

3. Under Start Server Service using this account, enter a Windows account username and password.

Note

This account needs the following privileges:

– In the Windows operating system, it needs to be in the Administrators group.