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

  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. Thanks for sharing such a nice article. EPOS Terminal i love your useful post for us. your idea is mind blowing that's why i would like to appreciate your work.

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

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

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

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

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

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

  10. Excellent post! !! epos system is really Good one. Really Thanks for this post....

  11. 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.

  12. Thank you for sharing some epos top quality information!...

  13. A lot of stuff in this post, epos system good one and has a lot of information to know about...

  14. Thanks for providing the information. epos systems Well done with the work.

  15. Thanks for some good write ups. epos system like to see more from you.