Registering a Designer database

When you start the program, the Connect to Infor EPM Designer dialog box opens. Here you administer database registrations and connect to the repository of the farm.

To register a Designer database:

  1. Click Creates a Designer database registration.
  2. Specify a name for the registration.
  3. Click Wizard.
  4. Select the OLE DB provider on the Provider tab and click Next.
  5. Specify the server name where the database is located on the Connection tab.
  6. Specify the required information to log on to the server.
    Note: When connecting to and working with the Designer repository database, we recommend that you connect with the dbo credentials.
  7. Select the database to use from the Select the database drop-down list.
    Note: If SQL Native Client 10.0 is selected as the provider, the Allow saving password option on the Connection tab does not work correctly. If you use SQL Native Client 10.0 without integrated security, specify the password in the Connection String field of the Register Database dialog. Specify the password as password=[sa password]. Use semi-colons (;) to separate attributes in the connection string.
  8. Click Test Connection. If the connections is successfully established, click OK.
  9. Select Allow saving password and click OK.
    The new Designer database registration is created.
  10. To edit a registration, select the registration from the drop-down list and click Edits the Designer database registration.
  11. To delete a registration, select the registration from the drop-down list and click Deletes the Designer database registration.