HP MFP Digital Sending Software (DSS) 5.0 - Required User Access Roles in External Database

Page 2 of 3 white paper
The first credentials, for the “initialize database using” user, are used only to initialize the
databases when DSS first works with them. These databases must already exist, but DSS will fill out
the database tables, keys and other structures as DSS requires. These credentials are used only for
database initialization and at no other time.
The credentials provided for “Access database using” are used for all other interactions between
DSS and the database other than initialization.
User Account Authentication
The two user accounts must be configured for SQL Server authentication. This can be seen using
SQL Server Management Studio. In the Security folder for the SQL Server instance open the Logins
folder and right click on the user name being checked and choose properties. In the properties
dialog the “SQL Server authentication” radio button should be selected, as shown below.
User Account Roles
SQL Server users have server wide roles and can also have database specific roles for databases
within the SQL instance. The table below gives the required minimum roles for each of the users
used by DSS.
User
Required Server Roles
Required Minimum
Database Roles in the
two DSS databases
Initialize Database using
public
db_owner
Access database using
public
db_datawriter, db_datareader
Document Attributes
Author: David Lerman
Product Models: DSS 5.01.xx