Creating the exceptions database schema for an SQL Server database
You must create the exceptions database schema that stores exception data.
- 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.
- 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.
- 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
- 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.
- To create the database schema and tables, enter the
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
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.