IMF Tune v7 - Enabling SQL Authentication

The IMF Tune web interface requires a Microsoft SQL backend database. MS SQL versions 2005 to 2014 are supported, including the free MS SQL Express editions.

For the system to work IMF Tune requires an SQL Server that supports both Windows Authentication and SQL Authentication. This is sometimes referred to as mixed mode authentication. In case SQL Authentication is not enabled, IMF Tune will be unable to upload any emails to the database server. Furthermore on starting up the configuration you will be greeted with a warning alerting you that IMF Tune is unable to connect to the database server.

NOTE: Even if SQL Authentication is disabled the registration process initiated from the IMF Tune configuration under Quarantine | Quarantine Database may still succeed without error.

In all the supported MS SQL versions, the steps to enable SQL Authentication are very similar. The differences are mostly a matter of variations in the SQL Management User Interface presentation.

Enable SQL Authentication in MS SQL 2005 and Later

The following is the procedure to enable SQL Authentication in case of MS SQL 2005. Although later versions introduced some UI changes, the same steps can be followed.

1. Open the SQL Server Management Studio.

2. Right-click the Server Node and select Properties

   

3. Select Security and from here, under Server authentication, select 'SQL Server and Windows Authentication mode'.

   

4. Click OK to save changes.

5. Restart the SQL server by right-clicking the server node again, and select Restart.