hMailServer: Database Configuration

Microsoft Dynamics GPIn the last post I showed the installation of hMailServer; in this one I’m going to cover the database setup.

If you followed the last post you should have the hMailServer password window on screen. If not start the hMailServer Database Setup utility from the start menu.

Enter the admin password configured during the installation and click OK:

hMailServer password

on the Welcome step, click Next:

hMailServer Database Setup - Step 1 of 7: Welcome

Choose the database server Owner; as I am installing this on a Dynamics GP test system which has a full SQL Server installation, I have selected the Use external database engine (MSSQL, MySQL or PostgreSQL) radion button. Click Next:

Setup - hMailServer: Select database server Owner

This is a new installation of hMailServer so leave the Create a new hMailServer database and click Next:

hMailServer Database Setup - Step 2 of 7: Select option

Leave the Microsoft SQL Server option selected and click Next:

hMailServer Database Setup - Step 3 of 7: Select database server Owner

Enter the Database server address (this can be either the Server Name or IP Adress), enter a Database name and choose your Authentication method.

During an installation, I typically select Use server authentication and enter the sa username and password. I do this to ensure the user I am using has all of the necessary permissions to create a database and all objects.

Click Next to proceed:

hMailServer Database Setup - Step 4 of 7: Enter sever connection information

You can then configure the hMailServer service dependency if the mail server is the same machine as the SQL Server (which in this example it is not).

Click NMext to proceed:

hMailServer Database Setup - Step 5 of 7: Set hMailServer service dependency

On the Finish stage, click Next to start the installation:

hMailServer Database Setup - Step 6 of 7: Finish

Once the installation is complete, click Close:

hMailServer Database Setup - Step 7 of 7: Completed

A final step allowing the hMailServer to be run will be displayed:

Setup - hMailServer Database Setup: Completing the hMailServer Setup Wizard

I’ll be covering the hMailServer Administrator in the next post in this series.

What should we write about next?

Your Name (required) –
Your Email (required) –

2 thoughts on “hMailServer: Database Configuration

  1. Attention: Ian Grieve:
    I downloaded and installed hMailServer 5.6.6 – B2383 earlier this year, and I have followed the steps given on your web site for database configuration. However, when I get to step 6 of 7 and click the “Next >” button, I receive the following error message:

    “Starting task…
    Please wait while creating database…
    ADO: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access

    I have searched online and learned that this error message is apparently caused by an
    erroneous connection string. I also have Microsoft Visual Studio 2017 installed, but have had no success in figuring out how to edit a connection string. The database exists, so where do I proceed from here? Thank you ( see Colossians 3:15, for example ) for your help. Keep in touch.

    Sincerely in Christ,
    Russell E. Willis
    P.S. – Please read Proverbs 23:23.

    1. Ian Grieve says:

      Is your SQL Server on the same machine as hMailServer?

      If not, sometimes this error can be because the firewall is blocking the port or Named Pipes is not enabled.

Leave a Reply

Your email address will not be published. Required fields are marked *