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

The FortiClient EMS installation also installs 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. You 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 2017.

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 Installation > Upgrade from a previous version of SQL Server.
  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 completes, click Finish.
To test the SQL server upgrade:

Running a short test on FortiClient EMS after the upgrade to verify proper operations is recommended. 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

The FortiClient EMS installation also installs 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. You 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 2017.

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 Installation > Upgrade from a previous version of SQL Server.
  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 completes, click Finish.
To test the SQL server upgrade:

Running a short test on FortiClient EMS after the upgrade to verify proper operations is recommended. 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.