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 (:).

   There are several important considerations to take into account when using the MSSQL Integrated Security.

   Ensure that atleast one of the following is true:

   1. Your machine isn't joined to the domain, but the SQL Server that you're connecting to is running on that same machine.
   2. Your machine is joined to the same domain that the SQL Server instance is running on and the login is set-up appropriately (See below).
   3. You are running in a MS Active Directory environment, and the login that you're using has rights to that SQL Server instance.

   In addition, you may need to change the login account used by the DRM service, since by default it uses the Local System account. This account most likely won't have permission to connect to MSSQL Server. Typically, when you run DRM Console, you're running it from an account that likely will have access to SQL Server (but check your MSSQL Server instance configuration to see which Windows logins it will allow, and what permissions they have), but the DRM Service will generally not be provisioned unless you deliberately assign it to use a login that has permissions to that SQL Server instance.

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.