Configuration and setup (legacy)

Deprecated since version 5.0: Post‑install configuration topics have moved under Post-install. This page remains while deep links are updated.

Following the initial installation of the package, proceed with the enablement and configuration.

Required configuration

Licensing

The Connector will not operate unless a license is installed. Follow License management (Post-Install) to install and update the license.

Update settings

A cloud installation requires manually updating the username and password. Use the same functionality to update other settings. See Update settings.

Optional configuration

Context menu

Using the context menu functionality is optional. It allows M-Files to automatically trigger SQL procedures, or for users to trigger SQL operations on demand.

Consult Installing the Context Menu to get started with the Context Menu.

Database mail

Database Mail is used for error notifications and can also be used to send reports and other notifications to users and third parties.

Consult Database Mail for enabling database mail.

Logging

MFSQL Connector includes a range of logging features. By default, detailed logging is switched on. If your deployment does not require detailed logging, set the following to 0.

To view the current status of the setting

Select value from mfsettings where name = 'App_DetailLogging'

To update the setting

Update mfsettings
set value = '0'
Where name = 'App_DetailLogging'

Review Using and managing logs for more detail on how the logs fit together.

From version 4.10.30.74 the Context Menu includes the ability to log context menu processing. Enabling logging for the context menu is covered in Enabling and configuring the VAF logging.

Agents

SQL Agent jobs are often used with MFSQL Connector procedures to automate processes. The following agents are automatically installed by the Connector.

Consult Using Agent for automated updates to enable the agents.

Powershell utilities

When SQL Express is used, SQL Agent is not available. The Connector includes a PowerShell utility to schedule procedures using Windows Task Scheduler.

Consult Setup powershell utilities to enable this method of automating procedures.