Configuration and setup¶

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 the Licensing Management to install and update the license.

Update settings¶

A cloud installation will require the manual updating of the username and password. The same functionality can be used to update other settings : Refer to Update settings.

Optional configuration¶

Database mail¶

Database mail is used for error messages to email 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 detail logging is switched on. However, if the use of MFSQL Connector does not require any detail logging, then the following setting can be set 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 to logs fit together.

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

Agents¶

SQL Jobs with SQL Agents are often used in conjunction 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, the SQL agent functionality for automation is not available. To this end the connector includes a powershell utility to schedule procedures using windows task scheduler.

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