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
- 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
Select 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
Select 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 Authentication
- Create an account with administration permissions, TrackingService for example or specify an existing one.
- Confirm with Next and close InstallShield Wizard with Finish.
Create administrator account for the database
Windows authentication
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 and confirm with Next.
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
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
SQL 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 authentication
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
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
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
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
Then Tracking Service can access the database with Windows authentication.