How to check DMZ server connection with internal SQL Server

Pre-Requisite: Create SQL Server account to have access (Full) to the Microix Databases and Read access to the MIP Databases. The new SQL account should be used in the Microix web.config file located on the IIS Server.

  <connectionStrings>
    <add name="MicroixConnectionString" connectionString="Data Source=(local);Integrated Security=False;User Id=userid;Password=password" providerName="System.Data.SqlClient"/>

Deploying Microix Cloud Companion and HTML applications on a DMZ server requires the DMZ server to have access to the internal SQL Server via the standard SQL port 1433.  Use the following setups below to confirm the DMZ server has access to the  SQL server. If any of the steps fail, most likely your firewall access from DMZ to the internal SQL server remains and issue and may need to seek assistance from your firewall vendor.



  1. Navigate to Control Panel>Administrator Tools>ODBC Data Source




  1. Click the ADD button and select  SQL Server



  1. Select your SQL Server Name form the list or enter the IP address and instance name if applicable



  1. Enter SQL server SA account information


  1. If connection was successful, a list of databases will be displayed when clicking on the database list


Creation date: 12/7/2021 12:11 PM      Updated: 12/7/2021 12:16 PM
image001.png

image001.png
image002.png

image002.png
image003.png

image003.png
image004.png

image004.png
image005.png

image005.png
OriginalEmail.eml

OriginalEmail.eml
Files   
image001.png
27 KB
image002.png
55.7 KB
image003.png
38.6 KB
image004.png
41.3 KB
image005.png
44 KB
OriginalEmail.eml
13.1 KB
get help Get help for this page