The scenario is that POS PC and Store database PC are joined to domain however they are on a remote location and without VPN access they cannot resolve Active directory user and FQDN. Instead of a domain account, we used local PC account to perform all actions on SQL and connect Retail POS through the same local user. We also used different credentials for POS and Store database pc, e.g. POSPC and StorePC which is perhaps the mistake we made.
After all setups for POS, when I started AX 2012 R2 Retail POS it stopped working, event viewer showed following error:
“Login failed. The login is from an untrusted domain and cannot be used with Windows authentication”
In order to resolve this error make sure of the following:
1. Username on POS and Store database PC must be SAME.
2. Password for both users must be SAME.
This user will authenticate POS user on Store database PC to connect to SQL database only if the username and password are the same.