Creating the exceptions database schema for an SQL Server database

You must create the exceptions database schema that stores exception data.

Procedure

If the computer that hosts the services tier is not the same as the computer that hosts the exceptions database, copy the scripts to the computer that hosts the exceptions database.
If the database is remote from the services tier, copy the scripts to the database server host.
Run the setup scripts.
1. Ensure that you are logged in as a user that can run the sqlcmd command and that has access to the scripts that were generated in the first step.
2. If you are creating the exceptions database in a new SQL Server database, rather than in an existing database such as the metadata repository, run this command to create the database:
```
sqlcmd -b -i esdb_db_creation.sql
```
3. To configure user permissions, enter the following command:
```
sqlcmd -b -i esdb_user_config.sql -vPASSWORD=esuserpwd
```
  where esuserpwd is the password for the Exceptions stage user's password.
4. To create the database schema and tables, enter the following command:
```
sqlcmd -b -i esdb_table_creation.sql
```
Test the connection with the following command:
On Linux® or UNIX:
```
RepositoryAdmin.sh -tc -rn ESDB -cn ESDB
```
On Windows:
```
RepositoryAdmin.bat -tc -rn ESDB -cn ESDB
```
If the connection fails, verify that you ran the database creation scripts correctly. Repeat the database creation process if necessary.