Several of the Lucity web products usually need to be installed into a DMZ environment. When setting up these applications there are several items to keep in mind:
Part of installing any of our web applications includes providing the Instance Name for the SQL Server or Oracle host so that the application can connect to the database. This may cause problems when installing our applications into a DMZ because often times a DMZ host does not have access to an internal DNS server and therefore can’t resolve the "Names" of internal hosts. The suggested way to solve this problem is to modify the hosts file. The hosts file tell 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 need you should configure your 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 is extension-less and is located at %SystemRoot%\system32\drivers\etc\.
Open the hosts file using a text editor.
The file will contain instructions for how to edit it.
Add a line for the SQL Server including the IP and Host Name. 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 web product be sure to enter the Instance Name (Athena) in step 4. The server will automatically translate it to the IP address(192.0.0.1).