Contents x
    Connection Configuration for Microsoft SQL Server
      • Print
      • PDF
      Contents

      Connection Configuration for Microsoft SQL Server

        • Print
        • PDF
        Article summary

        summary

        This is a help page for setting up Connection Configuration for Microsoft SQL Server.

        entry

        item nameindispensableContents
        NameYesEnter the name of the Connection Configuration to be used inside TROCCO.
        memoNoEnter a note of Connection Configuration to be used inside TROCCO.
        hostYesEnter a host name or IP address.
        destination portYesEnter the port number of the database to connect to.
        The default port number for Microsoft SQL Server is 1433.
        userYesEnter a user name for authentication.
        (computer) passwordYesPlease enter your password for authentication.
        Connecting via SSHNoSelect this option if you wish to connect via SSH (using SSH tunnel).
        For more information, please see Connecting via SSH Tunnel.
        SSLYesPlease select from the following　
      • Enforce SSL connections
      • Follow the settings on the Microsoft SQL Server side.
        • JDBC DriverYesSelect 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)
        • Was this article helpful?
        What's Next