Document toolboxDocument toolbox

FactoryLogix Learning

Add, edit, or delete a database connection

Owned by Adriane Hunt
Last updated: Sep 03, 2024
3 min read

administrator

Database Connections button

In the Database Connections area of Server Management, you can manage your FactoryLogix database connections. 

 

Note

For details about creating a FactoryLogix database, see Create and configure the FactoryLogix Database. For details about FactoryLogix system specifications, see Recommended system specification.

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 window



  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.




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

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

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.




  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.




  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.

 

Copyright © 2024 Aegis Industrial Software Corporation. All Rights Reserved.