Add an MSSQL Connection in JChem for Excel

    In the case of MSSQL databases, it is possible to connect to tables, views, and synonyms.

    To add an MSSQL connection, follow the steps below.

    1. Click the Import ribbon button under the Database group.

      images/download/attachments/1802405/Add_a_Connection_s1.png
    2. Click Add Connection or right-click the Connections root node and select Add Connection from the context menu. By default, the Save Password and the Encrypt Password checkboxes are ticked.

      images/download/attachments/1802405/Add_a_Connection_s2.png
    3. Select the MSSQL tab on the Manage Connections form.

    4. Enter the Connection Name.

    5. Enter the User Name and the Password.

    6. Enter the hostname or IP address where the MSSQL database can be found.

    7. Enter the port number.

    8. Enter the database name of the MSSQL database.

      images/download/attachments/1802405/Add_a_Connection_s8_MSSQL.png
    9. Click OK to save the connection.