You are here: Administrator's Guide > Installation Options > Distributed Installation > Installing for Active-Passive Failover > Configure the FME Server Database on a Separate Database Server

Configure the FME Server Database on a Separate Database Server

This section provides instructions on how to configure FME Server to use a separate database server. Configuring Microsoft SQL Server, PostgreSQL and Oracle running on both Windows and Linux are described.

Note: If you chose the Express Install option or selected to use the default FME Server Database Server with Distributed Install then you already have all that is required to run FME Server and there is no need to read this section.

Configuring FME Server to use a separate database server involves the following steps:

  1. Database Configuration: This involves setting up FME Server database tables and database users with permissions to access the FME Server database.
  2. Note: The specific way to set up database tables and user permissions on various production databases may differ depending on the available database tools and intended target platform.

  3. Enable connections: FME Server connects to the database when it starts. Therefore, ensure that your database server is running and configured to accept incoming connections before FME Server is started. The database must allow connections over TCP/IP with all machines on which the FME Server Core and FME Engines are installed.
  4. Post-configuration scripts: These scripts enable the installed services, sample workspaces, and notification subscribers.