Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
subtletrue
colourBlue
titleadministrator

...

Add a database connection

  1. Log onto the server or a machine where FactoryLogix Server Management is already installed. (The login account should have administrative rights to the database server if you are using Windows authentication.)

  2. Start FactoryLogix Server Management.

  3. In the Home window, select Database Connections.
    Database Connections windowImage Removed

    Database Connections windowImage Added


  4. Select the Add database connection Add database connection button button in the upper-right corner of the window.

  5. In the Add New Database Connection dialog, enter a name in the Database Connection Name field.
    Add New Database Connection dialogImage Removed

    Add New Database Connection dialogImage Added

  6. Under Server Name, enter a server name or select one from the drop-down.

  7. iconfalsetitle

    Under Log on to the server, select the applicable authentication type (Windows or SQL).

    Note


Note

...

If you use Windows authentication, the FactoryLogix system will use the credentials of the user who is logged into the system at the time that any database connection is required. When using a specific user name and password (SQL authentication), you must supply a user name and password in Server Management. The user name will be used for every database connection.

  1. In the Select or enter a Database Name field, select the name of the new database or enter a database name, then select OK.

    The new connection is added to the list in the Database Connections window and is now available to select as the default database if desired.

  2. When you're finished, select Save, then select Close to return to the Server Management Home window.

Edit a database connection

  1. Log onto the server or a machine where FactoryLogix Server Management is already installed. (The login account should have administrative rights to the database server if you are using Windows authentication.)

  2. Start FactoryLogix Server Management.

  3. In the Home window, select Database Connections.

  4. Select the database connection you want to edit on the left side of the window.

  5. Select the Edit database connectionEdit database connection buttonbutton in the upper-right corner of the window.
    Edit Database Connection dialogImage Removed

    Edit Database Connection dialogImage Added

  6. Make the desired changes to the database connection in the Edit Database Connection dialog, then select OK.

  7. When you're finished, select Save, then select Close to return to the Server Management Home window.

Delete a database connection

  1. Log onto the server or a machine where FactoryLogix Server Management is already installed. (The login account should have administrative rights to the database server if you are using Windows authentication.)

  2. Start FactoryLogix Server Management.

  3. In the Home window, select Database Connections.

  4. Select the database connection you want to delete on the left side of the Database Connections window.

  5. Select the Delete database connection Delete database connection buttonbutton in the upper-right corner of the window.

    Delete database connection messageImage RemovedDelete database connection messageImage Added
  6. When you see the confirmation message, select Yes to delete the database connection.

  7. When you're finished, select Save, then select Close to return to the Server Management Home window.