Testing Avalanche's Connection to a MSQL Database

Version 2

    Question

    How can I verify that Avalanche can communicate correctly with my external MSQL database?

     

    Answer

    You can test the connection from the Enterprise Server using the following SQLCMD;

    sqlconnecttst.JPG

     

    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.