Problem

-- In the DbConfig tool or at the installation, it is not possible to configure the database URL with an Instance.

-- The only information we can configure is the following:

Database host

Database port

Database name

User

Password

-- There is no option to add an Instance

Resolution

* Edit the datastoreconfig.xml in ../Interchange/config

* Replace:

<ConnectionURL>jdbc:jtds:sqlserver://{Host}:{Port}/{DatabaseName};SelectMethod=Cursor;sendStringParametersAsUnicode=false;socketTimeout=600</ConnectionURL>

BY

<ConnectionURL>jdbc:jtds:sqlserver://{Host}:{Port}/{DatabaseName};instance=name_of_the_instance;SelectMethod=Cursor;sendStringParametersAsUnicode=false;socketTimeout=600</ConnectionURL>