Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

...

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.

...

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.

If the SQL Server Login ID does not have sufficient privileges a message box is displayed and the installation will not proceed.  

...