Creating a SQL Server Database

To configure a SQL Server database for the Oracle Data Relationship Management repository:

1. Enter the user id and password which will be created as the login for the Data Relationship Management database.

   Caution:

   When creating a database user name or password, you cannot use the following symbols: at (@), slash (/), comma (,), and colon (:).

2. Enter the name of the database to create to hold the Data Relationship Management repository.

   Caution:

   Database names cannot begin with a number.

3. Do one of the following and then click Next:

   • Select Use server defaults for data files to use default settings for the path to and size for the database and log file.

   • Enter the path to and size for the data file and log file.

4. On the Application Administrator Creation page, enter a user name and password for the Administrator user and then click Next.
5. On the Create Configuration page, review the target repository information, and then click Next.

   Note:

   After the repository is created, you can save the log.

6. Do one of the following:

   • Click Finish to apply the changes to the current application.

     You are returned to the main screen of the console where you can review the settings.

   • Click Cancel to exit the wizard.

7. Click Save Configuration, otherwise connection information is lost when the console is closed.