• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Connecting to a Microsoft SQL Server database

Use the following procedure to connect to your Microsoft SQL Server database.

  1. Click the New icon in the Project panel at the top left corner of the window.

  2. Select Microsoft SQL Server in the Platform drop-down list at the top of the dialog box.

  3. Select the Standard option in the Mode drop-down list if you want to connect to the Microsoft SQL Server database in the standard mode.

    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been already used).

    • Provide the rest of connection information to the Microsoft SQL Server database: Server Port, Authentication method and Username. You can manually enter these values manually or select them from drop-down lists (Authentication method can only be chosen between SQL Server Authentication and Microsoft Authentication from the drop-down list).

    • Enter Password to complete the information about Microsoft SQL Server database connection.

    • Check the Use SSL option to establish a secure connection to the Microsoft SQL Server database.

    • Check the Trust server certificate option to specify that the driver can trust the server certificate when connecting to the Microsoft SQL Server database using TLS.
      Please note, that if the encrypt property is set to true and the trustServerCertificate property is set to true, the Microsoft JDBC Driver for SQL Server will not validate the SQL Server SSL certificate.

    • Press the Test button to verify that you can successfully connect to your Microsoft SQL Server database.

  4. Select the Connection String option in the Mode drop-down list if you would like to connect to the Microsoft SQL Server database using the special connection string.

    • Enter the Connection string manually or select it from the drop-down list (if it has been already used).

    • Press the Test button to verify that you can successfully connect to your Microsoft SQL Server database.