--- title: "Connection Configuration for Microsoft SQL Server" slug: "connection-configuration-sqlserver" updated: 2024-09-19T08:12:48Z published: 2024-09-19T08:12:48Z canonical: "documents.trocco.io/connection-configuration-sqlserver" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Connection Configuration for Microsoft SQL Server ## 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](/docs/connection-with-ssh-tunnel). | | SSL | Yes | Please select from the following Enforce SSL connectionsFollow the settings on the Microsoft SQL Server side. | | 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](/docs/data-source-rdbms-version-mapping). 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)` |