{"id":863,"date":"2012-06-04T09:11:48","date_gmt":"2012-06-04T09:11:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=863"},"modified":"2025-01-23T04:54:12","modified_gmt":"2025-01-23T04:54:12","slug":"solving-the-access-denied-error-in-sage-simply-accounting","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/","title":{"rendered":"Solving the Access denied error in Sage Simply Accounting"},"content":{"rendered":"

This may not be directly related to Sage (Accpac) 300 ERP but during migrations from Sage 50 – Canadian Editon (formerly known a Sage Simply accounting) we have come across this issue couple of times hence this blog.
\n\u201c[MySQL] [ODBC 3.51 Driver] Access denied for user ‘[username]@localhost’ [using password YES]<\/strong>\u201d
\nWhy do we get this error message?<\/strong>
\n\"\"<\/a>
\nWhen user tries to connect the Simply Accounting using a third party application, the above error message appears due to below mention situations;
\n1. Using the user that does not have data access rights. Or
\n2. Using invalid user name and password.
\nHow to solve this error?<\/strong>
\nIn order to decipher the above mentioned error\/problem, we need to carry out some simple steps;
\n1. Open Simply Accounting using the sysadmin<\/strong> user.
\n2.\u00a0\u00a0Once you have successfully logon to Simply Accounting, go to Setup<\/strong>-> Set Up Users & Roles\u2026 (Only sysadmin user have rights to access this option)<\/strong>
\n\"\"<\/a>
\n3. Then it will ask for password of \u201csysadmin\u201d<\/strong> user of simply accounting Company. Refer below snapshot.
\n\"\"<\/a>
\n4. Once you have successfully entered the sysadmin password. Click on OK button then following screen will be displayed.
\n\"\"<\/a>
\n5. Select the appropriate user from the list and click on \u201cModify User\u201d button, the below screen will get displayed.
\n\"\"<\/a>
\n6. Select appropriates rights by clicking \u201cRead-only access\u201d or \u201cRead\/Write access\u201d radio button and click on OK button.
\nIt will solve the error and the particular user will not get the error message. With few simple steps, one can avoid the MySQL error for other users as well.<\/p>\n","protected":false},"excerpt":{"rendered":"

This may not be directly related to Sage (Accpac) 300 ERP but during migrations from Sage 50 – Canadian Editon (formerly known a Sage Simply accounting) we have come across this issue couple of times hence this blog. \u201c[MySQL] [ODBC 3.51 Driver] Access denied for user ‘[username]@localhost’ [using password YES]\u201d Why do we get this\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-863","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"\nSolving the Access denied error in Sage Simply Accounting<\/title>\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\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Solving the Access denied error in Sage Simply Accounting\" \/>\n<meta property=\"og:description\" content=\"This may not be directly related to Sage (Accpac) 300 ERP but during migrations from Sage 50 – Canadian Editon (formerly known a Sage Simply accounting) we have come across this issue couple of times hence this blog. \u201c[MySQL] [ODBC 3.51 Driver] Access denied for user ‘[username]@localhost’ [using password YES]\u201d Why do we get this\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-04T09:11:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-23T04:54:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/\",\"name\":\"Solving the Access denied error in Sage Simply Accounting\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg\",\"datePublished\":\"2012-06-04T09:11:48+00:00\",\"dateModified\":\"2025-01-23T04:54:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Solving the Access denied error in Sage Simply Accounting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Solving the Access denied error in Sage Simply Accounting","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\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/","og_locale":"en_US","og_type":"article","og_title":"Solving the Access denied error in Sage Simply Accounting","og_description":"This may not be directly related to Sage (Accpac) 300 ERP but during migrations from Sage 50 – Canadian Editon (formerly known a Sage Simply accounting) we have come across this issue couple of times hence this blog. \u201c[MySQL] [ODBC 3.51 Driver] Access denied for user ‘[username]@localhost’ [using password YES]\u201d Why do we get this\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2012-06-04T09:11:48+00:00","article_modified_time":"2025-01-23T04:54:12+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/","name":"Solving the Access denied error in Sage Simply Accounting","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg","datePublished":"2012-06-04T09:11:48+00:00","dateModified":"2025-01-23T04:54:12+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/1.-Error-Message.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/04\/solving-the-access-denied-error-in-sage-simply-accounting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Solving the Access denied error in Sage Simply Accounting"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=863"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/863\/revisions"}],"predecessor-version":[{"id":35423,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/863\/revisions\/35423"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}