ADMINISTRATOR

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

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.
   
   
   

4. Select the Add database connection  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.

8. 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.

9. 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 connectionbutton 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 button 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.