Modify databases

The Databases page displays the installed components, database instances and database names. The available database types depends on the installed ControlSuite component's supported databases.

To modify a database, click the Edit icon beside its name to open the Configure Component window, and select a Database Type - SQL Server, SQL Server Compact Edition or Oracle.
If selecting SQL Server, modify the following:
  • Authentication Type - Windows or SQL Server.
    • Windows (default selection): select this option when the user running the Windows Service account connects to the database server.
    • SQL Server: enter the user credentials in the Login and Password fields, (this can be another Windows user or a SQL Server user).
  • Instance - use the default, or select another instance from the drop-down list, or click Find to search for one not in the list.
  • Database Name - Enter the name of the database or select another database from the drop-down list.
  • Click the Test button to verify the database and server and functioning. A green check-mark displays when validated.

If selecting SQL Server Compact Edition, enter the database Password, and click the Test button to verify the database and server and functioning.

Note: The initial SQL Server Compact database and default password are created automatically when Business Connect is installed.
If selecting Oracle, modify the following:
  • DNS - Enter the name of the DNS Server.
  • Login and Password - Enter the Login and Password of the user with admin rights to the Oracle server.
  • Click the Test button to verify the database and server and functioning. A green check-mark displays when validated.