# Create the ERP Connector Database

## Create the database

1. Create a new database named *Ec\_Vault* on the SQL server of your choice. In this example, we'll use the current instance of the Autodesk Vault SQL server.
2. Create a user account *ecuser* mapped to the Ec\_Vault database. We will use it later in the ERP Connector settings window to connect to the database.
3. Add the following user database role memberships for the Ec\_Vault database: `db_datareader`, `db_datawriter`, `db_owner`.

## Steps review 

Using the Microsoft SQL Server Management Studio, we created a new database named Ec\_Vault and assigned a user account to it. This database does not yet contain any tables (Data Interface) but is ready for the connection from the ERP Connector Vault add-in.

<figure><img src="https://2469526073-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdP4aGs76nJ1Aw5NABOmE%2Fuploads%2Fxuov7SkkFm8pezqj5hmR%2Fimage.png?alt=media&#x26;token=8afe8ea8-e531-4b9b-ae37-a56cf4ec7d6b" alt=""><figcaption></figcaption></figure>