Introduction

This document will explain the required SQL Server permission for running a successful database install or update of CapaInstaller with the Setup Wizard.

You need one of the following permissions, to run a successful install or update of the CapaInstaller database.

Element	Description
Install a new database	In order to create a new CapaInstaller database, you need one of the following server permissions. dbcreator, Create any database, or Alter any database.
Upgrade database	The used login needs to be a member of the db_owner role or be granted the permission Control (GRANT CONTROL TO [user]).
Install in an empty database	You can also install the CapaInstaller database in an already created empty database. In order to do this, the used login needs to be a member of the db_owner role.

Read more about permission on Microsoft.com.

SQL Server Permission configuration for Setup Wizard

Introduction

Related content