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.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?





Your Name (required) -
Your Email (required) -

5 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
    denied.”

    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.

  2. Brent Barbour says:

    I ran into the same problem as Russell. “ADO: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.” hMailServer is on the same machine as the SQL Server. This is for an internal network completely isolated from the internet so there is no firewall. I’m trying to setup a local email server to work with Autodesk Vault Professional because Vault Professional will communicate with the users via email and since our network has no internet access therefore no access to our emails, I was hoping hMailServer would be the solution for creating local email accounts for this isolated network.

    Thank you for posting these very informative instructions!!! …and any additional help you or anyone else who comes across my comment came give me!

    1. Ian Grieve says:

      Hi Brent,
      if on the same machine, a firewall won’t be the problem, but is Named Pipes active? SQL Server needs to be accessible.

      1. Brent Barbour says:

        Named Pipes? Where do I go to activate that? Please forgive me. I know very little about SQL. I’m just a Mechanical Engineer filling in at a small facility because our Network Administrator has moved on.

Leave a Reply

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