Dedicated mailbox server to build a database

As you know, the security of the database server is very important to the company, many companies for security not only

To configure the firewall, and try to make the database server only in the intranet, not the network.

My side is used sqlserver2008, familiar with sqlserver2008 comrades know, sqlserver2008

Database Mail can be configured, but that is only the client, if the server is not currently linked to the Internet (Internet),

You can not directly use some e-mail services in the extranet.

What to do, if in the intranet, can build a mailbox service, and can use the external network mailbox service forwarding, that

The perfect solution to this problem.

Now recommend an open source software to run on the Windows platform hMailServer

I use the 5.33 version, if you want to go to the next update, you can go to the official website: https://www.hmailserver.com/download

Here are the full steps:

1. Click Install Package

2. Follow the default way to install step-by-step

This way, setting the password is set at the time of installation.

3. Go to the Admin interface

4. Software localization

The configuration of the mail system in the network management, in the Apache configuration of the hMailServer installation directory under the Phpwebadmin directory, map to your Web service root directory, directory alias you arbitrarily,
I used the mailadmin. This allows you to access and manage the mail service through [http://www.abc.com/mailadmin/]. We have to do a little work before the commencement of the hmailserver.
Install directory, find the bin directory, there is a Hmailserver.ini file, you have to edit, the internet found in the Chinese language configuration file Chinese.ini copied to the hMailServer installation directory
In the language directory, open the Hmailserver.ini file, where [guilanguages] under Validlanguages=english,swedish this line, the equal sign after the addition of a Chinese, into this
: Validlanguages=chinese,english,swedish, save. Then in the hMailServer installation directory, find the Phpwebadmin directory, there is a config-dist.php file, open,
Found it

$hmail _config[' rooturl '] = "http://localhost/";
Modified to:

$hmail _config[' rooturl '] = "http://www.abc.com/mailadmin/";
The specific path is modified according to your own configuration in Apache. Keep looking down.

$hmail _config[' defaultlanguage ' = "中文版";
Modified to:

$hmail _config[' defaultlanguage '] = "Chinese";
Other motionless, saved as config.php.
If your PHP environment and Web services are normal, you can see the interface of the mail system Web management login by accessing [http://www.abc.com/mailadmin/] from the browser. Input with
User name administrator, password is the administrator password you set when installing hMailServer, click OK button. If garbled, please put hMailServer installation directory in Phpwebadmin
The index.php file in the record opens to find:

<meta http-equiv= "Content-type" content= "text/html; Charset=iso-8859-1 ">
Modified to:

<meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">

This way, if you think the English version is no problem, you don't need this step.

5. Set the domain name

6. Setting limits in the domain

7. Create a domain account

8. Configure a protocol address

In this step, if you just use the internal mailbox service, that is the right step, but if you need to send internal mail to the external mailbox, you can

Set up a brokered mailbox configuration in SMTP

7. as follows:

This is the configuration of SMTP

8. Configure SMTP Routing

Note that 7, 82 steps of the address marked with red box need the same

To this step completed, basically all finished, you can use Foxmail to build an account to try, if your mailbox server address does not do DNS mapping, directly with

The IP address is available.

There are a lot of useful things in it, we can slowly pondering their own.

Dedicated mailbox server to build a database