Modify your application server database

The Configure Database tool provides the ability to make changes to your SQL Server database, as well as change the database you want to connect to.

Before you begin

You must install SQL Server before you install Workflow. For more information, see Software Requirements in the Workflow IPI documentation.

About this task

In order for Workflow to connect to Microsoft® SQL Server at runtime, you must configure SQL Server to enable the db_owner role for the applicable login account. For more information, see Enable Connection between Workflow and SQL Server.

The Workflow installation automatically selects the default SQL Server instance. For example, if SQL Server 2012 and SQL Server 2008 are both installed, SQL Server 2008 may be the default instance. In this scenario, if you want to use SQL Server 2012 instead, you must select this instance as the default as part of manually configuring your SQL Server settings. For instructions, see steps 2 and 3 of this procedure.

Procedure

  1. Click Start > All Programs > General Electric > Workflow > Configuration > Configure Database.
    The Database Configuration page appears.
  2. Specify the SQL Server database settings for this application based on the configuration of your environment.
    To configure SQL Server settings...Then...
    Automatically
    1. Select the Use a local database with Windows Authentication check box.
      Note: To use this option, the following SQL Server conditions apply:
      • Installed locally, AND
      • Designated as default Local Host, AND
      • Uses Windows Authentication
    2. Proceed to step 4.
    Manually
    1. Clear the Use a local database with Windows Authentication check box.
    2. Proceed to step 3.
  3. Specify your SQL Server settings, as follows:
    1. In the Server field, enter or select the name of the SQL Server that you want to connect to.
      Note: If the SQL Server is installed locally with a default instance, you may enter localhost.
    2. In the Database field, enter the name of your SQL Server database, or click the drop-down arrow to search for all databases located on the specified server.
      Note: If the specified database does not exist, it will be created for you.
    3. From the Authentication list, select the type of authentication that you want to use, and then proceed based on your selection.
      • If you select Windows Authentication, proceed to step 4.
      • If you select SQL Server Authentication, proceed to step 3.d.
    4. Enter the User Name and Password that are configured for SQL Server authentication, and then proceed to step 4.
  4. Click Save, and then click Exit.