Installation login
The SQL Server login that is used during installation needs the following permissions to install and modify the schemas of each Discover database.
This login can either be the NT account of the user running the Discover installation or a separate SQL Server login that is provided to the Discover Database Manager as a secondary step after the main installation completes.
The simplest option is to use an NT Account that has SQL Server admin privileges or provide a SQL login with that level of access. If that is not possible a login with the following roles and permissions is required to successfully complete the Discover database installation:
- Required Database Roles:
db_ddladmin
db_datareader
db_datawriter
- Required Database Permissions:
ALTER ANY LOGIN
ALTER ANY USER
CREATE DATABASE
CREATE SCHEMA