Sunday, February 24, 2013

AX For Retail POS Error on startup: 'Retail POS cannot connect to a database. Try again later or see your system administrator'

In AX for Retail R2 (or earlier versions), upon clicking on a POS terminal with the intent of opening a POS session, you are slapped in the face by the lovely error 'Retail POS cannot connect to a database. Try again later or see your system administrator.' (see Figure 1 below)

Figure 1

This error (obviously since its stated as such) is because the system tries to open a POS session but cannot access the POS store's database. It then advises you to either try again or see the system administrator. The waiting game is because this could be because of a network issue and the terminal cannot connect to the DB. A DB connection is required for a store to be brought up as the one terminal one DB topology is no longer supported with AX for Retail after the 2009 release.

First off, since this message could be due to a number of reasons, check the Event Viewer's 'Application' Windows Log. It will save time and contains good stuff. As an example, if its the first time a user is attempting to get into a POS terminal and they got this error, the windows log may show: "Login failed for user 'CONTOSO\user1'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]"

Solution to this error
If a user group of 'POS Users' is assigned to that DB and the user is not assigned to that group in the domain, they won't be able to get access. If you do add that user to the appropriate group in the domain, the user will need to log off their OS and get back in before they see the changes or else they will say 'It's still broken'.

Here are some steps the system administrator will do to resolve the issue if its not the above. Check that:
  • The user has access to that database in SQL.
    • See above example
  • the POS configuration file is pointing to the correct DB
    • Right clicking on the POS icon->'Open File Location' will take you to the config file if you have privileges.
    • Then check the contents of the POS.EXE.CONFIG file.
      • The <AXRetailPOS> node will have the DB server in the StoreDatabaseConnectionString attribute as 'Data Source=[THEDBSERVER];Initial Catalog=[THESTOREDBNAME]...'. Make sure these are correct.
  • the Store DB server is up and running.
  • the Store DB's SQL service is running and not stopped or paused
  • the POS terminal machine can access the store DB
    • Ping the POS store's DB server from the terminal with this issue
      • If not able to, make sure the firewall isn't stopping the program from accessing the DB.


  1. Great post I loved it I now know much more about eventbrite! Very well written keep up the good work.
    Pos Systems For Retail


      We have been having recent complains from individuals about how they lost money 💵 to SPAMMERS who call themselves HACKERS or BANK LOAN OFFERS. They are all over the internet sharing false testimonies. Please do not fall for their lies for this is just a way to LURE you to them.

      They say lies in the likes of -:
      ▪️Bitcoin Auctioning ▪️Western Union Hack
      ▪️Blank Credit Card ▪️Clearing Criminal Records
      ▪️Loan Offers. ▪️Bank Account Loading
      ▪️Changing University Grades & so on.
      These are all lies and you shouldn’t fall for them.

      🏵 PLUGGERS🏵 is here to help you Recover all your Money 💵 that you have been Ripped of.
      We are a group of Computer💻 Experts who are memebers of the “HACKERONE” Forum. We have dedicated ourselves to help Victims of these SCAM(s) recover all the Money that has been taken falsely from them.

      If you have been a victim of these Thieves, then you need to contact us as soon as possible so you can get your money back.
      No. +1 (808) 600 0773 ( Number also available on WhatsApp)

      Please know that we do not charge you for Fund Recovery Service, Our Funds Recovery Service is to help and so it’s Free.

      We also provide Legit Hacking Services such as-:
      🔸Phone Hacking/Cloning
      🔸Email Hacking & Password Recovery
      🔸Social Media Hacking & Passowrd Recovery
      🔸Deleted Files Recovery 🔸Mobil Tracking
      🔸Virus detection & Elimination.

      No. +1 (808) 600 0773 (number also available on WhatsApp)

  2. this content is very nice.If you are looking for best Point of Sale solutions, we have the branded POS Equipment with original manufacturer warranty.

  3. Thank You for Wonderful information sharing, Epos System this article about Epos Systems..

  4. This blog post is Wonderful. EPOS Terminal Thanks for sharing this great stuff. Keep sharing this kind of stuff,Thank you.

  5. The Most company are like this Epos System .it is easy way to keept information.

  6. This is an interesting blog that you have posted, epos system you shares a lot of things about epos system.

  7. Thanks for sharing unique information, epos good post to share.

  8. fantastic post. epos Its pretty interesting article, love this kind of post...

  9. Thanks a lot for that information to share. epos system That was a really Interesting post and I would really like to know more and more.

  10. Thanks for the informative blog. compare epos system prices uk It helped a lot in gathering some useful information. I would like to see some more useful stuff.

  11. Thanks a lot for that wonderful information. compare epos systems Great stuff, will looking forward for some more postings...

  12. Thanks for sharing a nice post. epos systems It's been really informative and helped me a lot. Keep posting more posts.

  13. This is Great.loves to like read your post.Keep it up.Please Visit:

    pos cash register
    cafe pos systems
    retail systems

  14. Thanks for sharing actual content on pos system. Wonderful content.... keep sharing
    Get more details related to retail pos system.

  15. It was a really awesome post  epos system and I would really like to know more.

  16. Thanks for postingepos software for retail your valuable thoughts with us & our readers. Thank You

  17. This is nice postemperium epos software for retail for better understanding and thanks a lot for sharing keep it up...

  18. Hi,

    I’m really impressed with your blog article, such great & useful knowledge you mentioned here

    Pos Systems For Cafes Compare the best hospitality POS systems today and find the perfect electronic for cafes, hotel & restaurants at

    URL :-

  19. Good information to know and right to the point. epos software Thanks for this well written post, i'll follow up for more updates if you keep posting them.

  20. Your post is extremely helpful. epos system I will keep following. Thank you for sharing this information.

  21. Thanks for sharing this useful information epos regarding There is a very good information on your blog.

  22. Thanks for sharing such unique information tablet pos system uk which are in actual fact as well as helpful for us.Keep it up.....

  23. Interesting blog. epos software It would be great if you can provide more details about it. Thanks you.

  24. Gdax transaction time out Wait! Are you out of time while doing Gdax transaction? Well, sometimes transaction take long time due to various technical issues. It’s better to reach the safest places in such error some time. You can dial Gdax Support Number 1-888-764-0492 to reduce your worry. The well-accomplished experts have all the admissible and easy to implement solutions to every Gdax technical issues. The experts fix the errors from the roots in minimal time. Visit

  25. Good information really appreciate your post. epos It was very informative and increase my knowledge, Keep up posting.

  26. Restaurant billing software loaded with CRM can be an aid to restaurants looking for customer commitment and retention.
    Restaurant pos software India
    Restaurant pos system India
    Restaurant billing software
    billing software for restaurant

  27. Nice blog, very interesting to read
    I have bookmarked this article page as i received good information from this.

    Low Price ERP Software in India | ERP Software in India

    Customized ERP Software in Hyderabad | SAP ERP in India

  28. Nice post. Thanks for sharing this useful, epos system providing the information. Well done with the work.

  29. I love reading your blog epos system for small business and look forward to all your posts! Keep up the superb work!

  30. I have bookmarked this blog page as i received good information from this.
    Here are some related information checkout;

    Best POS Software in Hyderabad | POS Software for Retail Stores in Hyderabad

    cloud based erp software in hyderabad | cloud erp

  31. Very interesting and useful information! Love to read. Waiting for next blog!

    Point of Sale in Pakistan
    Pos in Pakistan

    Best Epos system and Epos Software in UK for all businesses point of sale.
    Contact us now
    Epos Software in Nottingham
    Epos systems in Nottingham
    Epos system for restaurants in Nottingham
    Point of Sale System in Nottingham

  33. Dear Admin! I think this is the best article I ever read in my life, kindly write more about Pos system in Pakistan and Pos software in Pakistan

  34. Intelepos is offering a simple but effective Epos System for Takeaway to manage your entire business smoothly. It will help you to learn about the customers’ requirements and preferences. Our Epos has the following features:
    Real-time order tracking
    Daily, weekly, and monthly sales report
    Manage your staff
    Epos system for takeaway
    Epos system and Software for takeaway

  35. Keep up with latest updates on point of sale system., with iOS and Android support coming soon. Restaurants, coffee shops, bars, retail, street food.

  36. you raise good points keep sharing more in detail for brief look. if you need to know really a best system which have best of all in term of functions, reliability, options and pricing then you can visit here. EPOS for Takeaways
    best epos system uk

  37. The article is very good and informative. Thank you for the author.
    For Electric Scooter in Bangalore please contact greendrivemotors.

  38. Fantastic post. epos software Lots of useful information here. thank you in your effort!

  39. Fantastic post. epos software Lots of useful information here. thank you in your effort!

  40. Retail POS Software in UAE, Single Lisence Software in UAE, Cashiers Software in UAE
    Retail Software in UAE, Safe Shopping Multiple Payment Options Express Delivery GCC Gamers Moneyback Guarantee.

  41. Nice post and thanks for sharing. keep going

    Are you searching for any inexpensive billing software in Chennai? We are here

    Billing Software in Chennai
    Restaurant Billing Software in Chennai

  42. Nice post,Thanks for given this information of epos system. pos software uk Your idea is mind blowing that's why i would like to appreciate your work.

  43. thanks for sharing this website it is very useful informating . such it wonderful articlebusy software 21 download

  44. Authentic content..very knowledgeable.. thanks for this post.
    Tally on Cloud Server
    Tally on AWS

  45. Really good work there. Informative and helpful. Appreciate it. But might be looking for Retail Shop POS System Software in New York

  46. It is a proficient article that you have shared here. I got some different kind of information from your article which I will be sharing with my friends who need this info. Thankful to you for sharing an article .If you are looking for tailor made erp software for your business,get a free consultationcustom erp software development