IMail - Configure SQL Server for use with IMail

How to configure SQL Server for use with IMail.

Step 1: Go into ODBC Configuration manager.

Add a new System DSN:

Next Select Add…

Select Finish.

Assign a name for the System DSN connection you are creating. This will be the name used later for the IMail External Database connection. Then add the IP address of the SQL server in the field provided. After doing so select Next:

Make sure to select SQL Server Authentication rather than Windows NT authentication.

Please enter the Login ID on the SQL Server for the database you have created, then enter the password. Next, select Client Configuration.

Be sure to select TCP/IP under Network Libraries; after doing so the IP address and Port Number should already be filled in. Select OK in this screen then select Next.

Make sure to select "Change the Default Database to:" and select the database that you have created on SQL Server. After doing so select Next, then select Finish.

Go ahead and select Test Data Source.

It should complete successfully as shown below. (Assuming that all the information was entered correctly.)

The next step is to go into IMail Administrator | localhost | Add Host. Select the domain that you wish to give external database connectivity to.

Select External Database then Configure:

On this screen you will see several items that we used in ODBC Manager when we created the IMail System DSN.

Under ODBC System Data Source Name you enter will the System DSN followed by a semicolon then uid= which is the userid or Login for the SQL server, followed by a semicolon then pwd= which is the password for the Login id.

After doing this please select OK followed by Apply. Stop and re-start all of IMail’s services. That should be it. IMail will write the table for you.