This article describes the required permissions for SQL Server for proper installation, upgrade and operation of the Simplify Suite.
For Simplify Suite, Tricerat supports both Windows authentication (preconfigured user or current user) and SQL Server authentication.
As a matter of best practices, Tricerat recommends that customers configure mixed mode authentication to allow both Windows authentication and SQL Server authentication for the widest flexibility when installing SQL server in your environment.
Microsoft SQL Server Database Versions Supported
Windows Authentication vs SQL Server Authentication
For both Windows Authentication mode authentication modes and SQL Server authentication mode, a SQL Server Login ID is required as a prerequisite before installing or upgrading the Simplify Suite.
Required SQL Server Login ID Example
For each user that will need to install or upgrade the Simplify Suite, a SQL Server Login ID is required. You cannot rely on the NT AUTHORITY\Authenticated Users for installing/upgrading the Simplify Suite.
See the graphic below for an example of a SQL Login ID for a Windows Authentication user:
The first time Simplify Suite is installed in a customer’s enterprise, a database will be created during the installation process. Customers Customer DBA's should not pre-create the database.