Assemblage often utilizes a firm's existing SQL Databases to collate various pieces of content.  Trumpet establishes those connections via Windows authenticated connections. 

This configuration is available from the main Assemblage application, Tools->Preferences, Database connections:

You can have multiple Database connections

To add a database connection, select "Add"

When the "Add..." window opens, provide a Connection name (typically the name of the software):

The Connection URL field should be completed as follows:

jdbc:jtds:sqlserver://<servername>/<databasename>;instance=<instancename>

Where you replace the "<servername>" with the actual server name, <databasename> with the actual database name and <instancename> with the actual instance name

Encryption

If your SQL server requires SSL encryption, you will need to add ssl=required to the end of your Connection URL. 

e.g. jdbc:jtds:sqlserver://SRV2014/JUNXURE;instance=JUNXURE;ssl=required

e.g. jdbc:jtds:sqlserver://SRV2014/PC;instance=PORTFOLIOCENTER;ssl=required

Testing

To ensure that you have access to the appropriate database, select "Test Connection"

If your connection is set properly, you will see the a green check, along with the dialog that says "Successful connection made!"