Fortinet black logo

EMS Administration Guide

Upgrading Microsoft SQL Server Express to Microsoft SQL Server Standard or Enterprise

Upgrading Microsoft SQL Server Express to Microsoft SQL Server Standard or Enterprise

FortiClient EMS is installed with Microsoft SQL Server Express, which has a file size limit of 10 GB per database. Log entries recorded in the database are rotated on a schedule of seven days (one week) by default. If the FortiClient deployment is large, the database size may reach the 10 GB limit over time. The FortiClient EMS administrator may upgrade the default SQL Server installation from Express to Standard or Enterprise edition. The database file size limit for these editions is in the PB range, which is unlimited for most practical usage. When managing more than 5000 endpoints, installing SQL Server Standard or Enterprise instead of SQL Server Express is recommended.

Microsoft SQL Server Express is free. All other editions require a license from Microsoft.

See the following Microsoft documentation on upgrading between editions called Upgrade to a Different Edition of SQL Server (Setup).

The EMS database is saved in the C:\Program Files\Microsoft SQL Server\MSSQL12.FCEMS\MSSQL\DATA\FCM_root.mdf file in the EMS host server. This file's size should remain below the 10 GB limit for Microsoft SQL Server Express.

Upgrading a database edition outside normal production hours is recommended.

The minimum SQL Server version that FortiClient EMS supports is 2014. It is recommended to use SQL Server 2017 or a later version.

To upgrade SQL Server Express to Standard or Enterprise:
  1. Attach the SQL Server 2017 installation media to the FortiClient EMS server.

    The installation media is a DVD or ISO file. If using the DVD, insert the DVD into the EMS host computer (host server). If your host server is a virtual machine, use the ISO file.

  2. Run the SQL Server setup application wizard.
  3. In the SQL Server Installation Center wizard, go to Maintenance > Edition Upgrade.
  4. Enter the product key.
  5. Accept the license terms, then click Next.
  6. Under Select Instance, in the Specify the instance of SQL Server dropdown list, select FCEMS. Then, click Next.
  7. Under Ready to upgrade edition, click Upgrade.
  8. After the upgrade is complete, click Finish.
To test the SQL server upgrade:

It is recommended to run a short test on FortiClient EMS after the upgrade to verify proper operations. A simple test may be to:

  1. Connect FortiClient on one or two test endpoints to FortiClient EMS.
  2. Create a new custom group in FortiClient EMS and add the test endpoints to it.
  3. Create a new endpoint profile.
  4. Create a new endpoint policy that is configured with the newly created profile. Assign the policy to the new custom group.
  5. Check that FortiClient on the test endpoints received the new profile.

Monitor the system closely over the first few days for any unusual behavior.

Upgrading Microsoft SQL Server Express to Microsoft SQL Server Standard or Enterprise

FortiClient EMS is installed with Microsoft SQL Server Express, which has a file size limit of 10 GB per database. Log entries recorded in the database are rotated on a schedule of seven days (one week) by default. If the FortiClient deployment is large, the database size may reach the 10 GB limit over time. The FortiClient EMS administrator may upgrade the default SQL Server installation from Express to Standard or Enterprise edition. The database file size limit for these editions is in the PB range, which is unlimited for most practical usage. When managing more than 5000 endpoints, installing SQL Server Standard or Enterprise instead of SQL Server Express is recommended.

Microsoft SQL Server Express is free. All other editions require a license from Microsoft.

See the following Microsoft documentation on upgrading between editions called Upgrade to a Different Edition of SQL Server (Setup).

The EMS database is saved in the C:\Program Files\Microsoft SQL Server\MSSQL12.FCEMS\MSSQL\DATA\FCM_root.mdf file in the EMS host server. This file's size should remain below the 10 GB limit for Microsoft SQL Server Express.

Upgrading a database edition outside normal production hours is recommended.

The minimum SQL Server version that FortiClient EMS supports is 2014. It is recommended to use SQL Server 2017 or a later version.

To upgrade SQL Server Express to Standard or Enterprise:
  1. Attach the SQL Server 2017 installation media to the FortiClient EMS server.

    The installation media is a DVD or ISO file. If using the DVD, insert the DVD into the EMS host computer (host server). If your host server is a virtual machine, use the ISO file.

  2. Run the SQL Server setup application wizard.
  3. In the SQL Server Installation Center wizard, go to Maintenance > Edition Upgrade.
  4. Enter the product key.
  5. Accept the license terms, then click Next.
  6. Under Select Instance, in the Specify the instance of SQL Server dropdown list, select FCEMS. Then, click Next.
  7. Under Ready to upgrade edition, click Upgrade.
  8. After the upgrade is complete, click Finish.
To test the SQL server upgrade:

It is recommended to run a short test on FortiClient EMS after the upgrade to verify proper operations. A simple test may be to:

  1. Connect FortiClient on one or two test endpoints to FortiClient EMS.
  2. Create a new custom group in FortiClient EMS and add the test endpoints to it.
  3. Create a new endpoint profile.
  4. Create a new endpoint policy that is configured with the newly created profile. Assign the policy to the new custom group.
  5. Check that FortiClient on the test endpoints received the new profile.

Monitor the system closely over the first few days for any unusual behavior.