How can I verify that Avalanche can communicate correctly with my external MSQL database?
You can test the connection from the Enterprise Server using the following SQLCMD;
NOTE THAT IF A CONNECTION IS SUCCESSFUL THEN YOU WILL SEE 1>. IF NOT YOU WILL SEE LOGIN FAILED, AND NEED TO FIGURE OUT WHY IT IS FAILING. OBVIOUSLY IF THE ESERVER CAN'T COMMUNICATE WITH THE DB AVALANCHE WILL NOT RUN.