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.

41 comments:

  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

    ReplyDelete
    Replies
    1. ARE YOU A VICTIM OF FALSE HACKERS & BANK LOAN SCAM⁉️

      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.
      WHO ARE PLUGGERS⁉️
      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.
      Email-: globalpluggers@gmail.com
      No. +1 (808) 600 0773 ( Number also available on WhatsApp)

      Note:
      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.

      Contact-:
      Email globalpluggers@gmail.com
      No. +1 (808) 600 0773 (number also available on WhatsApp)








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

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

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

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

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

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

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

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

    pos cash register
    cafe pos systems
    retail systems

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

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

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

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

    ReplyDelete
  14. 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

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

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

    ReplyDelete
  17. 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

    ReplyDelete
  18. https://intelepos.com/
    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

    ReplyDelete
  19. 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

    ReplyDelete
  20. 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

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

    ReplyDelete
  22. 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

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

    ReplyDelete
  24. Retail POS Software in UAE, Single Lisence Software in UAE, Cashiers Software in UAE
    https://gccgamers.com/retail-pos-software.html
    Retail Software in UAE, Safe Shopping Multiple Payment Options Express Delivery GCC Gamers Moneyback Guarantee.
    1634616994301-7

    ReplyDelete
  25. 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.

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


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

    ReplyDelete
  28. Very interesting post. Thanks a ton! Was searching for the information on Online Point Of Sale in US

    ReplyDelete
  29. Wonderful post.Its pretty interesting. EPOS system in London I really loved reading through this Blog... Thanks for sharing...

    ReplyDelete