{"id":51032,"date":"2022-04-26T09:28:16","date_gmt":"2022-04-26T16:28:16","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?post_type=docs&p=51032"},"modified":"2022-06-15T05:22:35","modified_gmt":"2022-06-15T12:22:35","slug":"prerequisites-for-configuring-transact-with-microsoft-sql-server-2","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/","title":{"rendered":"Prerequisites for Configuring Transact with Microsoft SQL Server"},"content":{"rendered":"

See Platform Configurations and Third-Party Integrations<\/a> to determine which operating system, database, and third-party integrations are supported for your version of Ephesoft Transact.<\/p>\n

If using an existing database, make sure you have SQL Server client installed. For that, download and install the following software on the Ephesoft server in the following order before installing Ephesoft Transact.<\/p>\n

<\/a>Transact 2022.1.00 and Above<\/h2>\n
    \n
  1. Microsoft\u00ae SQL Server\u00ae 2012 Native Client \u2013 QFE<\/a> (Version 11.4.7001.0)<\/li>\n
  2. Microsoft\u00ae ODBC Driver 17 for SQL Server\u00ae<\/a> (Version 17.8.1)<\/li>\n
  3. Microsoft\u00ae Command Line Utilities 15 for SQL Server\u00ae<\/a> (Version 15.0.2)<\/li>\n<\/ol>\n

    <\/a>Transact 2020.1.06 and Below<\/h2>\n
      \n
    1. Microsoft\u00ae SQL Server\u00ae 2012 Native Client \u2013 QFE<\/a> (Version 11.4.7001.0)<\/li>\n
    2. Microsoft\u00ae ODBC Driver 13.1 for SQL Server\u00ae \u2013 Windows, Linux, & macOS<\/a> (Version 13.1.4413.46)<\/li>\n
    3. Microsoft\u00ae Command Line Utilities 13.1 for SQL Server\u00ae<\/li>\n<\/ol>\n

      Note:<\/strong> Please visit the Ephesoft Support Portal<\/a> to download Command Line Utilities 13.1 for SQL Server.<\/p>\n

      Workaround for Transact 4.5.0.2:<\/strong><\/p>\n

      There is a compatibility issue with SQL Server 2008R2 (shipped as a part of Ephesoft Transact installer) on Windows Server 2012R2, Windows 8 or higher version. For information regarding Windows OS and SQL Server version-wise compatibility, please refer to the following Microsoft article:<\/p>\n

      https:\/\/support.microsoft.com\/en-us\/help\/2681562\/using-sql-server-in-windows-8-and-later-versions-of-windows-operating<\/a>.<\/p>\n

      However, there is a workaround provided by Microsoft to make Windows Server 2012R2 (and Windows 8.1) compatible with SQL Server 2008R2. This can be done by installing an additional Service Pack. You can find all the required information here:<\/p>\n

      https:\/\/docs.microsoft.com\/en-US\/troubleshoot\/sql\/general\/sql-server-windows-8-later-versions<\/a><\/p>\n

      Note: Microsoft SQL Server 2008R2 is not compatible with Windows 10 or Windows Server 2016.<\/em><\/p>\n","protected":false},"featured_media":0,"parent":44681,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"\nPrerequisites for Configuring Transact with Microsoft SQL Server | 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=\"Prerequisites for Configuring Transact with Microsoft SQL Server\" \/>\n<meta property=\"og:description\" content=\"See Platform Configurations and Third-Party Integrations to determine which operating system, database, and third-party integrations are supported for your version […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-15T12:22:35+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/\",\"name\":\"Prerequisites for Configuring Transact with Microsoft SQL Server | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2022-04-26T16:28:16+00:00\",\"dateModified\":\"2022-06-15T12:22:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/#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\":\"Install and Upgrade\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Additional Resources\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Windows\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Prerequisites for Configuring Transact with Microsoft SQL Server\"}]},{\"@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":"Prerequisites for Configuring Transact with Microsoft SQL Server | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Prerequisites for Configuring Transact with Microsoft SQL Server","og_description":"See Platform Configurations and Third-Party Integrations to determine which operating system, database, and third-party integrations are supported for your version […]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/","og_site_name":"Ephesoft Docs","article_modified_time":"2022-06-15T12:22:35+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/","name":"Prerequisites for Configuring Transact with Microsoft SQL Server | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2022-04-26T16:28:16+00:00","dateModified":"2022-06-15T12:22:35+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/prerequisites-for-configuring-transact-with-microsoft-sql-server-2\/#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":"Install and Upgrade","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/"},{"@type":"ListItem","position":4,"name":"Additional Resources","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/"},{"@type":"ListItem","position":5,"name":"Windows","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/"},{"@type":"ListItem","position":6,"name":"Prerequisites for Configuring Transact with Microsoft SQL Server"}]},{"@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\/51032"}],"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=51032"}],"version-history":[{"count":4,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/51032\/revisions"}],"predecessor-version":[{"id":51366,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/51032\/revisions\/51366"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/44681"}],"next":[{"title":"Database Type Matching in Server.xml and Windows Registry","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/database-type-matching-upgrade\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31646"}],"prev":[{"title":"Best Practices for a Multi-Server Environment","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/windows\/best-practices-multi-server-environment\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31640"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=51032"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=51032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}