Installing the Tracking database

253 views 1

To install the tracking database, please follow the steps below:
  • Copy Setup.exe onto the SQL server and open it
  • Select the desired language → InstallShield Wizard opens and click Next
Start InstallShield Wizard

Start InstallShield Wizard

  • Select the SQL server, on which you wish to install Tracking database
  • Then specify how do you wish to access the database:
    • Windows authentication or
    • SQL server authentication
  • Confirm with Next
Choose Database server and authentication to SQL server

Choose Database server and authentication to SQL server

  • Choose a name for the database in which the information about print jobs will be stored: PrintJobTracking for example (following Illus., upper arrow)
  • In case of a software update, you can select an existing database by clicking on the button Browse
Choose database server and Authentication mode

Choose database server and Authentication mode

 

Select authentication mode for the users

Authentication mode defines how the users and Tracking Service access the stored print data via Tracking Report Engine.

Note! SQL server authentication is recommended.

SQL server Authen­tication

  • Create an account with administration permissions, TrackingSer­vice for example or specify an existing one.
  • Confirm with Next and close InstallShield Wizard with Finish.
Create administrator account for the Database

Create administrator account for the Database

Windows authenti­cation

If you choose Windows Authentication all users and servers need to be members of the same domain. Users can log on with their user name and their domain password.

Choose Windows authentication mode

Choose Windows authentication mode

Choose Windows authentication and confirm with Next.

Inherit groups from Active Directory

Inherit groups from Active Directory

You can select user groups from the Active Directory which should be able to access Tracking Database. For this, click Advanced.

Define administrator groups and user groups

Define administrator groups and user groups

During installation of Tracking database, database administrators (top arrow in upper Illus.) with read and write permissions will be created, as well as users with read permissions only (bottom arrow).

Finally, conclude Tracking database installation in InstallShield Wizard with Install and Finish.

 

Manage Tracking Database

Database (in this example: PrintJobTracking)

Database (in this example: PrintJobTracking)

Open a management tool for the database, as for example Microsoft SQL Server Management Studio Express. With this tool, you can administer the database created by the installer.

With SQL authenti­cation

When you install Tracking database with SQL authentication, a user account will be created with read permissions on the database. This name of the user account will be TrackingUser.

Enable protocols

Enable protocols

To access the SQL server remotely, open SQL Server Manager and enable the protocols Named Pipes and TCP/IP . Then start the SQL server browser in the services folder.

With Windows authentication

To ensure the Tracking Service gets access to the SQL server, open Management Studio Express and enter with a right click in the folder Security on New and Login.

Install access for Tracking Service on the SQL server

Install access for Tracking Service on the SQL server

Create a new account according to this sample (following Illus.):

<domain>\<Server name of Tracking Service>$

in this example: mydomain\ps13$

Install login for Tracking Service

Install login for Tracking Service

Put a checkmark at the database, which is configured for Tracking – in this example: PrintJobTracking (upper arrow in following Illus.) – and a checkmark each at db_owner and at TREAdmin (lower arrows).

User mapping

User mapping

Then Tracking Service can access the database with Windows authentication.

Previous Page
Next Page

Was this helpful?