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¶
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.