{"id":89,"date":"2022-04-26T10:43:46","date_gmt":"2022-04-26T10:43:46","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=89"},"modified":"2024-10-17T11:41:40","modified_gmt":"2024-10-17T11:41:40","slug":"acumatica-cant-establish-connection-to-database-server","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/","title":{"rendered":"Acumatica – Can’t establish connection to database server"},"content":{"rendered":"\n

Acumatica ERP allows us to connect database server using Windows Authentication as well as SQL Server Authentication. There are some SQL configuration settings which needs to be handled for seamless connectivity of Acumatica with SQL server.<\/p>\n\n\n\n

In this blog, we will be looking into one of the resolutions for the error that occurs at the time of configuring the Acumatica Instance. <\/p>\n\n\n\n

While creating new Acumatica Instance, the initial step is to create database server connection as shown in the below image.<\/p>\n\n\n

\"Database<\/a><\/p>\n\n\n

The below screenshot demonstrates the connectivity with \u201cSQL Server Authentication\u201d and the same issue appears if \u201cWindows Authentication\u201d is selected instead of SQL server.<\/p>\n\n\n

\"SQL<\/a><\/p>\n\n\n

On click of Next button the error will pop up as below.<\/p>\n\n\n\n

Error: –<\/strong> “Can\u2019t establish connection to database server”.<\/p>\n\n\n\n

The left section of the below screenshot displays the Inner Message of an error whereas the right section displays the stack trace.<\/p>\n\n\n

\"Acumatica<\/a><\/p>\n\n\n

Steps to resolve the above error are as follows:<\/strong><\/p>\n\n\n\n

    \n
  1. Open SQL Server Configuration Manager on which we have configured the Acumatica Database.<\/li>\n\n\n\n
  2. Navigate to \u201cSQL Server network Configuration\u201d > Protocols for SQL > TCP\/IP.<\/li>\n\n\n\n
  3. Make sure that the TCP\/IP is in Enabled mode.<\/li>\n\n\n\n
  4. Double Click on TCP\/IP to open the Properties dialog box.<\/li>\n\n\n\n
  5. Move on the \u201cIP Addresses\u201d tab.<\/li>\n\n\n\n
  6. Scroll to the end of the list and ensure that the IPALL<\/strong> has TCP Port value as 1433.<\/li>\n\n\n\n
  7. Once done, restart the SQL Server and proceed with creating the database instance again.<\/li>\n<\/ol>\n\n\n

    \"TCP<\/a><\/p>\n\n\n

    This is how we can resolve the connection issue while creating the database instance for Acumatica ERP<\/a>.<\/p>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"

    Acumatica ERP allows us to connect database server using Windows Authentication as well as SQL Server Authentication. There are some SQL configuration settings which needs to be handled for seamless connectivity of Acumatica with SQL server. In this blog, we will be looking into one of the resolutions for the error that occurs at the\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,3,14],"tags":[4,37,16,38,39],"class_list":["post-89","post","type-post","status-publish","format-standard","hentry","category-acumatica-customization","category-acumatica-erp","category-acumatica-services","tag-acumatica","tag-acumatica-cant-establish-connection-to-database-server","tag-acumatica-erp","tag-database-server","tag-windows-authentication"],"yoast_head":"\nTroubleshooting Acumatica Database Connection Issues<\/title>\n<meta name=\"description\" content=\"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting Acumatica Database Connection Issues\" \/>\n<meta property=\"og:description\" content=\"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-26T10:43:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-17T11:41:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png\" \/>\n<meta name=\"author\" content=\"greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/\",\"name\":\"Troubleshooting Acumatica Database Connection Issues\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png\",\"datePublished\":\"2022-04-26T10:43:46+00:00\",\"dateModified\":\"2024-10-17T11:41:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png\",\"width\":715,\"height\":478},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Acumatica – Can’t establish connection to database server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshooting Acumatica Database Connection Issues","description":"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting Acumatica Database Connection Issues","og_description":"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2022-04-26T10:43:46+00:00","article_modified_time":"2024-10-17T11:41:40+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png","type":"","width":"","height":""}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/","name":"Troubleshooting Acumatica Database Connection Issues","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png","datePublished":"2022-04-26T10:43:46+00:00","dateModified":"2024-10-17T11:41:40+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"Troubleshooting guide for Acumatica users facing database connection issues. Learn how to resolve connection problems efficiently.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/04\/img-1.png","width":715,"height":478},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/04\/26\/acumatica-cant-establish-connection-to-database-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Acumatica – Can’t establish connection to database server"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=89"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":2622,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/89\/revisions\/2622"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}