Several of the Lucity products should be installed in a DMZ environment. When setting up these applications, keep in mind:
Part of installing any Lucity application includes providing the Instance Name for the SQL Server host so that the application can connect to the database. This requirement may cause problems when Lucity applications are installed into a DMZ, because often a DMZ host does not have access to an internal DNS server and can't resolve the "names" of internal hosts. The best way to solve this problem is to modify the hosts file. The hosts file tells the server in the DMZ that Server Name = IP address. General information about hosts files >>
To maintain network security and allow the applications to access the data they require, Lucity suggests that administrators configure the database hosts to run over a static port, and then allow access to that port from the DMZ.
Host File Example
How To Modify The Hosts File
Find the hosts file on the server in the DMZ.
The hosts file has no extension. It's located at: %SystemRoot%\system32\drivers\etc\.
Open the hosts file using a text editor.
Add a line for the SQL Server including the IP and host name. (The file contains editing instructions.) Do not include any information about the SQL instances, port number, etc..
Example:192.0.0.1 Athena #internal SQLServer
Save and Close the hosts file.
When installing a Lucity product, be sure to enter the Instance Name (Athena) in Step 3. The server will automatically translate it to the IP address (192.0.0.1).
