Planning and prerequisites¶
Audience¶
Use this before any installation to confirm requirements, choose the right deployment model, and prepare accounts, ports, and permissions. This page is Release 5–aligned.
What you’ll decide here¶
Deployment model: single-server, split M-Files/SQL, cloud/hosted, or high availability (cluster)
Connector components to include: SQL Assemblies (always), SQL tables, views, procedures and functions (always), VAF (always), UIX v2 Context Menu (optional), Web API (cloud or cross-domain)
Install method: standard installer (recommended) or manual scripts (restricted/locked-down SQL)
Supported versions (Release 5)¶
Windows Server 2022+ (64-bit ODBC)
M-Files Server: New Desktop (UIX v2). Classic Desktop works with a UIX v1 fallback package
.NET Framework 4.8
SQL Server 2016+ (Express, Standard, Enterprise)
Permissions and accounts¶
M-Files - A dedicated MFSQL Connector vault user (preferred: M-Files authentication) with Vault Admin rights - System Admin rights required during install/config; can be removed post-install
SQL Server - Installer must have sysadmin privileges (or equivalent for manual script path) - A SQL Auth user (default: MFSQLConnect) in the MFSQL database, member of MFSQLConnect_db role. The user and role are created by the installer and manual script installation.
Web/API (if used) - Web server service account and SSL certificate for HTTPS
Network and endpoints¶
M-Files Server: gRPC/HTTPS endpoint (cloud) or local server
SQL Server: instance and port accessible from VAF/Web API
Web API (if used): HTTPS URL reachable from M-Files Server (cloud → SQL)
Deployment models (choose one)¶
Single-server (M-Files + SQL on one server)
Split servers (M-Files and SQL on separate servers)
Cloud/hosted (M-Files Cloud or separate domains; requires Web Server with IIS for the Web API for context menu actions)
High availability (SQL cluster; copy assemblies to each member)
Installer outputs and locations¶
The Installer is available for download from the Laminin website https://lamininsolutions.com/download-mfsql-connector/#MFSQL-download
Running the installer will: - Extract the installer files from the to the target folder - Register the VAF package in the vault (if selected) - Create the MFSQL database (if it does not exist) - Deploy SQL objects (tables, procedures, functions, assemblies) to the database - Optionally install the UIX v2 Context Menu and Web API components - Generate example scripts and configuration files for post-install steps - Save all outputs to the installer folder C:Program Files (x86)Laminin SolutionsMFSQL Connector Release 5[MFSQL_database] including:
60-Addons (signed cloud VAF build; Web API package MFSQLConnectWebAPI.zip; helper PowerShell scripts)
Content package (vault structure updates)
DatabaseScripts (saved by installer version 4 files with the SQL scripts)
Example scripts (Note that these scripts have all been included in this documentation. The examples script will be removed in the foreseeable future.)
Vault applications (signed VAF package MFSQLConnectorVaultApp.zip; UIX v1 fallback MFSQLContextMenuUIXV1.mfappx; UIX v2 MFSQLContextMenuUIXV2.zip)
Licensing¶
The application only operates with a valid license; see Licensing for the different types of licenses and conditions.
Contact support to obtain a license or for any licensing inquiries.
The installation of the license is covered in License management (Post-Install).
Next steps¶
Proceed to Install and pick your scenario
Then complete Post-install configuration
Validate with Validate and smoke tests
Topology diagram¶
MFSQL Connector topologies (single-server, split servers, cloud)¶