SQL Server Permission configuration for Setup Wizard
- Martin Gudme Søndergaard
Owned by Martin Gudme Søndergaard
Nov 14, 2023
Loading data...
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.