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.

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 2014 (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.

It is recommended to do a database edition upgrade outside normal production hours.

  1. Attach the SQL Server 2014 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.

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.

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 2014 (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.

It is recommended to do a database edition upgrade outside normal production hours.

  1. Attach the SQL Server 2014 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.