This article contains general information about database requirements for Simplify Suite and also describes the required permissions for Microsoft SQL Server for proper installation and operation of Simplify Suite.
- Microsoft SQL Server 2008
- Microsoft SQL Server 2012
- Microsoft SQL Server 2014
- Microsoft SQL Server 2016
- Microsoft SQL Server 2017
- Microsoft SQL Server 2019
Tricerat supports both full SQL Server and SQL Server Express as database platforms.
During the creation of the database, permission to use the database and execute stored procedures is granted to all authenticated users via the
GRANT EXECUTE TO [NT AUTHORITY\Authenticated Users] SQL command.
This is so SQL Server stored procedures installed in the database can execute without disruption or error.
During Simplify Suite installations on satellite machines when the destination database already exists, important checks are performed to make sure the database conforms to the minimum database version schema level for the Simplify Suite version being installed.
Co-Requisite Database Updates Required During Tricerat Version Upgrades
When Simplify Suite has been installed on one or more machines, subsequent installation of a more recent version of Simplify Suite on a machine where Simplify Suite has been installed previously can potentially trigger updates to the destination database version schema version level.
This is an important way Tricerat can deliver database schema changes to customers.
RULE: If Simplify Suite v6.6 has been deployed to a customer environment, installing Simplify Suite v6.7 (or later) requires all machines to be updated nearly simultaneously.
This is because a Simplify Console (and other important Tricerat processes) running at v6.6 may not be not compatible with a Simplify Suite database running v6.7 (or later).
After evaluation and quality assurance in a controlled test environment is complete, customers should plan to deploy a new Simplify Suite version across the entire enterprise nearly simultaneously.
Least-Required Operating Privileges
After installation or upgrade of Simplify Suite, the least-required SQL permissions needed for most customers to launch Simplify Console are 'db_datareader' and 'db_datawriter'.
End users Users can be granted only 'db_datareader' access, in which case the Simplify Console becomes a read-only tool suitable for viewing only.
The SQL Login ID must also have permission to execute the stored procedures within the Simplify database.
To grant this permission do this, the following query can be used:
USE [<database name>]
GRANT EXECUTE TO [<SQL Login ID>]
GRANT EXECUTE TO [TriceratDatabaseUser]
|List by label (Content by label)|