This article describes the required permissions for SQL Server for proper installation, upgrade and operation of the 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
Windows Authentication vs SQL Server Authentication
...
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:
...
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.
...