# SQL Server Permission configuration for Setup Wizard

> The SQL Server permissions required to install or update the CapaInstaller database with the Setup Wizard.

Source: https://docs.capaone.com/capainstaller/installation-and-maintenance/database-settings-and-maintenance/sql-server-permission-configuration-for-setup-wizard/  
Product: CapaInstaller — a separate CapaSystems product; do not apply this page to any other.

# 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*, C*reate 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](https://msdn.microsoft.com/en-us/library/ms191291.aspx).