{"id":12614,"date":"2017-11-03T06:14:33","date_gmt":"2017-11-03T06:14:33","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=12614"},"modified":"2022-03-01T14:18:43","modified_gmt":"2022-03-01T21:18:43","slug":"connecting-to-mssql-database-over-ssl","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/","title":{"rendered":"Connecting to a MSSQL Database Over SSL"},"content":{"rendered":"

This page describes how to configure and connect to Microsoft SQL Server over an SSL connection. <\/span>Perform the following steps:<\/span><\/p>\n

    \n
  1. Stop Ephesoft Transact.<\/span><\/li>\n
  2. Download the\u00a0<\/span>jtds-1.3.1.zip <\/b>file from the Downloads<\/strong> page of the Ephesoft Customer Support portal<\/a>.<\/span><\/li>\n
  3. Extract the contents of the <\/span>jtds-1.3.1.zip <\/b>file to a temporary location.<\/span><\/li>\n<\/ol>\n

    JavaAppServer Changes<\/b><\/h3>\n
      \n
    1. Go to <\/span>[Ephesoft_Directory]<\/span><\/i>\\JavaAppServer\\lib.<\/span><\/li>\n
    2. Backup and delete the existing <\/span>jtds-*.jar<\/b> files.<\/span><\/li>\n
    3. Copy the extracted <\/span>jtds-1.3.1.jar <\/b>to the <\/span>lib <\/b>folder.<\/span><\/li>\n
    4. Open <\/span>EphesoftTransact.exe <\/b>as an administrator. This executable is located at <\/span>[Ephesoft_Directory]<\/span><\/i>\\JavaAppServer\\bin.<\/span><\/li>\n
    5. Select the <\/span>Java <\/b>tab.<\/span><\/li>\n
    6. Add the following parameter to the <\/span>Java Options <\/b>field:<\/span><\/li>\n<\/ol>\n
      Djsse.enableCBCProtection=false<\/span><\/pre>\n
      Application Changes<\/b><\/h3>\n
        \n
      1. Go to <\/span>[Ephesoft_Directory]<\/span><\/i>\\Application\\WEB-INF\\lib.<\/span><\/li>\n
      2. Repeat steps 5\u20136.<\/span><\/li>\n<\/ol>\n
        Server XML Changes<\/b><\/h3>\n
          \n
        1. Backup the existing <\/span>server.xml <\/b>file, located at <\/span>[Ephesoft_Directory]<\/span><\/i>\\JavaAppServer\\conf.<\/span><\/li>\n
        2. Open the <\/span>server.xml <\/b>with an editor.<\/span><\/li>\n
        3. Update the following connection string by adding \u201cssl=require\u201d.<\/span><\/li>\n<\/ol>\n
          jdbcUrl=\u201djdbc:jtds:sqlserver:\/\/localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode= true;prepareSQL=3;<\/span>ssl=require<\/b>;\u201d<\/span><\/pre>\n
          Certificate Import<\/b><\/h3>\n
            \n
          1. Import the certificate in the Java Keystore.\u00a0<\/span><\/li>\n<\/ol>\n
            Note: <\/b>Ensure the database is configured properly for encryption. Refer to the following Microsoft support article: <\/span>How to Enable SSL Encryption for an Instance of SQL Server by Using Microsoft Management Console<\/span><\/a>.<\/span><\/p>\n","protected":false},"featured_media":0,"parent":23474,"menu_order":3,"comment_status":"closed","ping_status":"open","template":"","doc_tag":[],"yoast_head":"\nConnecting to a MSSQL Database Over SSL | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting to a MSSQL Database Over SSL\" \/>\n<meta property=\"og:description\" content=\"This page describes how to configure and connect to Microsoft SQL Server over an SSL connection. Perform the following steps: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-01T21:18:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/\",\"name\":\"Connecting to a MSSQL Database Over SSL | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2017-11-03T06:14:33+00:00\",\"dateModified\":\"2022-03-01T21:18:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"System Configuration\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Database Connection and Configuration\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Connecting to a MSSQL Database Over SSL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecting to a MSSQL Database Over SSL | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Connecting to a MSSQL Database Over SSL","og_description":"This page describes how to configure and connect to Microsoft SQL Server over an SSL connection. Perform the following steps: […]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/","og_site_name":"Ephesoft Docs","article_modified_time":"2022-03-01T21:18:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/","name":"Connecting to a MSSQL Database Over SSL | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2017-11-03T06:14:33+00:00","dateModified":"2022-03-01T21:18:43+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"System Configuration","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/"},{"@type":"ListItem","position":4,"name":"Database Connection and Configuration","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/"},{"@type":"ListItem","position":5,"name":"Connecting to a MSSQL Database Over SSL"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/12614"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=12614"}],"version-history":[{"count":6,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/12614\/revisions"}],"predecessor-version":[{"id":50463,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/12614\/revisions\/50463"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/23474"}],"next":[{"title":"Database Permissions","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/2502"}],"prev":[{"title":"Connecting an Oracle Database to Ephesoft Transact","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connectivity-oracle\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/11323"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=12614"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=12614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}