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.

...

  • 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.  

...