Introduction


Products such as Tricerat's Simplify Suite typically use either Windows credentials or SQL Server credentials for authentication and to secure access to Microsoft SQL Server databases.
For version 6.3 (and later), Tricerat supports a new authentication mode called Static Windows Authentication.
This document describes how Tricerat products implement database credentials and authentication.


Authentication Modes


For version 6.3 (and later), three authentication modes are supported:



Windows Authentication


In this mode, the credentials of the current logged-on user are used to secure connections to Tricerat databases.


SQL Authentication


In this mode, SQL Server credentials are used to secure connections to Tricerat databases. The SQL Server credentials are separate from each user's Windows credentials.


Static Windows Authentication


In this mode, Windows credentials are used to secure connections to Tricerat databases. The credentials used are separate from individual users' Windows logon credentials.


Product Support


This matrix shows the database authentication modes supported for Tricerat products:


Why No 'Windows Authentication Supported'?


For Simplify Suite, interactive programs such as Simplify Console are launched by logged-on users. For other Tricerat products, there is no 'logged-on Windows user'. ScrewDrivers Print Server, for example, is an unattended process that runs in the background but needs database access when Print Job Reporting is configured.


Installation Dialogs


During installation, every Tricerat product is 'database aware'. If a product or a selected feature requires database access, the installer prompts for database access credentials.


Example: Simplify Suite


Here's an example of a Simplify Suite installation dialog on a Windows 2012 R2 Server machine highlighting the Static Windows Authentication configuration option:


  Example: Service Based Printers


Here's an example of a Service Based Printers installation dialog on a Windows 2012 R2 Server machine showing the configuration options:


Microsoft SQL Server Configuration



For any Tricerat database-oriented product, a SQL Login ID is required.
The SQL Server configuration steps needed will vary based on the Tricerat product authentication mode selected.
Please contact Tricerat Support with questions and requests for assistance.