{"id":4743,"date":"2025-03-06T05:05:42","date_gmt":"2025-03-06T05:05:42","guid":{"rendered":"http:\/\/localhost\/localerrors\/dup-installer\/?p=4743"},"modified":"2025-03-06T05:05:46","modified_gmt":"2025-03-06T05:05:46","slug":"sage-error-40960","status":"publish","type":"post","link":"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/","title":{"rendered":"Resolve Sage 300 Error 40960"},"content":{"rendered":"\n<p>Sage 300 is the flagship ERP (Enterprise Resource Planning) software offered by the Sage group. With this, you can manage accounting, manufacturing, distribution, inventory, payments, sales, and more.<\/p>\n\n\n\n<p>Error 40960 is related to the database connection in Sage 300 software. Sage 300 error <strong>40960<\/strong>:cannot access database, the configuration for the database has to be corrected to resolve this error.<\/p>\n\n\n\n<p>The exact error message is shown&#8230;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Sage 300 Error: \u201cCannot access database (error=40960)<\/p>\n<\/blockquote>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Post Navigation<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/#causes-of-error-40960-in-sage-300\" >Causes of Error 40960 in Sage 300<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/#solutions-to-fix-sage-300-error-40960-connection-problem\" >Solutions to Fix Sage 300 Error 40960 Connection Problem<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/#solution-1-double-check-your-dsn-settings\" >Solution 1: Double-check your DSN Settings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/#solution-2-solve-the-connection-issue\" >Solution 2: Solve the Connection Issue<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/#how-can-bigxperts-help-you\" >How Can BigXperts Help You?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading block-less-h2\" id=\"causes-of-sage-error-40960\"><span class=\"ez-toc-section\" id=\"causes-of-error-40960-in-sage-300\"><\/span>Causes of Error 40960 in Sage 300<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The cause for Sage error 40960 can be that a User is using a DNS to database setup points to the wrong server.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the 32-bit DSN (Data Sources) settings<\/li>\n\n\n\n<li>Click on the DSN used by Sage 300<\/li>\n\n\n\n<li>Select Configure<\/li>\n\n\n\n<li>Correct all the settings for the DSN<\/li>\n\n\n\n<li>Click on Save<\/li>\n\n\n\n<li>Now restart the system and resume using the software.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/\">Troubleshoot Sage 300 Error 3014<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading block-less-h2\" id=\"solution-resolve-connection-problem\"><span class=\"ez-toc-section\" id=\"solutions-to-fix-sage-300-error-40960-connection-problem\"><\/span>Solutions to Fix Sage 300 Error 40960 Connection Problem<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To solve the Sage 300 error 40960 confirm to system DNS used in ODBC is the correct SQL login credentials. The easiest way to troubleshoot this issue is to simply disable each of the security software, and then try connecting to the database.<\/p>\n\n\n\n<p>If this is the case, then follow the steps provided below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Disable the firewall and check if you still get Sage error 40960<\/li>\n\n\n\n<li>If yes, then go to Advanced Settings for Windows firewall<\/li>\n\n\n\n<li>Click on Inbound Rules and create a new rule for the port through which Sage connects to the database<\/li>\n\n\n\n<li>Do the same for Outbound rules<\/li>\n\n\n\n<li>Save the name and description of these rules for future reference.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-1-double-check-your-dsn-settings\"><\/span>Solution 1: Double-check your DSN Settings<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To begin with, you have to open the 32-bit Dash setting.<\/li>\n\n\n\n<li>Then you have to select DSN using Sage 300.<\/li>\n\n\n\n<li>After that, you have to click on Configure and make the necessary changes in the DSN setting.<\/li>\n\n\n\n<li>In the last, you have to select save.<\/li>\n<\/ul>\n\n\n\n<p><strong>By way of DSN configuration<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first thing you have to do is navigate to the 32-bit DSN (Data Source) setting.<\/li>\n\n\n\n<li>After that, you have to select the DSN used by Sage 300.<\/li>\n\n\n\n<li>Then click on configure.<\/li>\n\n\n\n<li>You have to make sure that all the settings of the DSN settings are correct.<\/li>\n\n\n\n<li>Then save the file<\/li>\n\n\n\n<li>Then restart the system and resume using the software.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-2-solve-the-connection-issue\"><\/span>Solution 2: Solve the Connection Issue<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First of all, disable the firewall and verify that the Sage 40960 error is fixed.<\/li>\n\n\n\n<li>If the problem is fixed, then select Advanced Windows Firewall.<\/li>\n\n\n\n<li>After that, you have to select the inbound rule and create a new port rule that connects the SEZ to the database.<\/li>\n\n\n\n<li>Execute the content outbound rule.<\/li>\n\n\n\n<li>In the last, you have to save the name and description.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/fix-sage-error-42000\/\">Fix Sage 300 Error 42000<\/a><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-can-accountingerrors-help-you\"><span class=\"ez-toc-section\" id=\"how-can-bigxperts-help-you\"><\/span>How Can BigXperts Help You?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Diagnosing and fixing errors sometimes requires knowledge of the software, windows, and database. Not every organization can hire people who specialize in all three round-the-clock <a href=\"https:\/\/www.bigxperts.com\/sage\/errors\/\">Sage error support<\/a> helpdesk is available through chat, call, or schedule a meeting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage 300 is the flagship ERP (Enterprise Resource Planning) software offered by the Sage group. With this, you can manage accounting, manufacturing, distribution, inventory, payments, sales, and more. Error 40960 is related to the database connection in Sage 300 software. Sage 300 error 40960:cannot access database, the configuration for the database has to be corrected&hellip;&nbsp;<a href=\"https:\/\/www.bigxperts.com\/sage\/sage-error-40960\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Resolve Sage 300 Error 40960<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":87048,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-4743","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-errors"],"featured_image_src":"https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg","author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_featured_image_src":{"full":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg",840,300,false],"thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-150x150.jpg",150,150,true],"medium":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-300x107.jpg",300,107,true],"medium_large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-768x274.jpg",768,274,true],"large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg",840,300,false],"1536x1536":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg",840,300,false],"2048x2048":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg",840,300,false],"neve-blog":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960.jpg",840,300,false],"web-stories-poster-portrait":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-640x300.jpg",640,300,true],"web-stories-publisher-logo":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/troubleshoot-Sage-300-Error-40960-150x54.jpg",150,54,true]},"uagb_author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_comment_info":0,"uagb_excerpt":"Sage 300 is the flagship ERP (Enterprise Resource Planning) software offered by the Sage group. With this, you can manage accounting, manufacturing, distribution, inventory, payments, sales, and more. Error 40960 is related to the database connection in Sage 300 software. Sage 300 error 40960:cannot access database, the configuration for the database has to be corrected&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/comments?post=4743"}],"version-history":[{"count":2,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4743\/revisions"}],"predecessor-version":[{"id":87049,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4743\/revisions\/87049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media\/87048"}],"wp:attachment":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media?parent=4743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/categories?post=4743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/tags?post=4743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}