summary
This is a help page for setting up Connection Configuration for Microsoft SQL Server.
entry
| item name | indispensable | Contents |
|---|---|---|
| Name | Yes | Enter the name of the Connection Configuration to be used inside TROCCO. |
| memo | No | Enter a note of Connection Configuration to be used inside TROCCO. |
| host | Yes | Enter a host name or IP address. |
| destination port | Yes | Enter the port number of the database to connect to. The default port number for Microsoft SQL Server is 1433. |
| user | Yes | Enter a user name for authentication. |
| (computer) password | Yes | Please enter your password for authentication. |
| Connecting via SSH | No | Select this option if you wish to connect via SSH (using SSH tunnel). For more information, please see Connecting via SSH Tunnel. |
| SSL | Yes | Please select from the following |
| JDBC Driver | Yes | Select the version of the JDBC driver that connects to the Microsoft SQL Server server. Different drivers support different versions of Microsoft SQL Server. For details, please refer to the Data Source - RDBMS Version Mapping Table. Depending on the version of SQL Server you are using, you can choose from the following JDBC Driver 8.2 (Microsoft SQL Server 2012, 2014, 2016, 2017, 2019)jTDS Driver 1.3.1 (Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, 2012) |