{"id":17427,"date":"2024-05-21T12:20:43","date_gmt":"2024-05-21T16:20:43","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=17427"},"modified":"2024-06-23T16:02:43","modified_gmt":"2024-06-23T20:02:43","slug":"sql-server-ssl-connection","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/sql-server-ssl-connection\/","title":{"rendered":"SQL Server SSL Connection"},"content":{"rendered":"

Since SQL Server has changed the functionality and default behavior of their driver, this article will go over the basic ODBC and JDBC connections required for the IRI software backend (CoSort <\/span>SortCL<\/span><\/a> engine in Voracity) and job design front-end (<\/span>IRI Workbench<\/span><\/a>, respectively, to Microsoft SQL Server databases on-premise or in the cloud which use encrypted connections.<\/span><\/p>\n

The article is broken down into three different configurations:<\/span><\/p>\n

    \n
  1. Setting up the drivers using SSL.<\/span><\/li>\n
  2. Bypassing the need for certificates for SSL connections.<\/span><\/li>\n
  3. Disabling the driver encryption if the database is not using SSL.<\/span><\/li>\n<\/ol>\n

    This article is not a replacement for the <\/span>previous article<\/span><\/a> on setting up connections to SQL Server. This is due to the fact that older versions of SQL Server databases do not support the latest drivers, so the previous article is still relevant to those with older database versions.<\/span><\/p>\n

    Prerequisite<\/span>: In order to set up both ODBC and JDBC for a Secure Sockets Layer (SSL) connection, an SSL certificate that is provided by the Database Administrator is needed.<\/span><\/p>\n

    There are two options when it comes to connecting IRI software to an SQL Server database with SSL enabled:<\/span>
    \n<\/span><\/p>\n

      \n
    1. Using the SSL certificate provided by the DBA.\u00a0<\/span><\/li>\n
    2. Bypassing the certificate. This is only recommended for test or development environments.<\/span><\/li>\n<\/ol>\n

      Using Certificates<\/strong><\/h3>\n

      This section details how to set up both ODBC and JDBC connections using the SSL certificate. To set up these connections, it is necessary to know what type of encryption is being used by the instance of the database server.<\/span><\/p>\n

      There are two options for <\/span>encryption<\/span><\/a>:<\/span><\/p>\n

      Force Encryption<\/span><\/i><\/p>\n