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 or SQL Server Compact Edition.

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.

The initial SQL Server Compact database and default password are created automatically when Business Connect is installed.