Microsoft SQL Server Requirements

You can use Microsoft SQL Server 2012, 2014, 2016, 2017, 2019, or later with its latest service pack as the vault database engine. These Microsoft SQL Server editions are supported: Microsoft SQL Server Express, Standard, and Enterprise. Refer to Microsoft documentation to make sure that your Microsoft SQL Server edition has the necessary features and capabilities for your environment.

M-Files supports the use of Microsoft SQL Server on Microsoft Windows. With a cloud-based M-Files environment that you manage yourself, you can also use Microsoft Azure SQL Database Managed Instance as the vault database engine.

Loading the Microsoft SQL Server assembly

M-Files uses an SQL server assembly that must be used in the SQL server instance for M-Files to operate. Usually, M-Files loads this assembly to the SQL server instance automatically. However, it can be necessary to manually allow the use of the assembly, if, for example, M-Files does not have sufficient permissions in the SQL server instance. For instructions, refer to the support article M-Files and SQL Server 2017 compatibility). If the SQL server assembly is updated, you must repeat the process.

Enabling Microsoft SQL Server features

Enable the features given here to use Microsoft SQL Server as the M-Files database engine.

Instance features:

  • Database Engine Services
  • Reporting Services, Native Mode (if reporting is used)

Shared features:

  • Management Tools, Basic
  • Management Tools, Complete (if reporting is used)