Hello,
A little bit of context:
We have a stage environment which contains an exact copy of the production, from a few months ago. Several differences are:
- Different passwords for several users, including ax-service related users
- Two or three missing users in the stage environment.
We want to refresh our stage environment with the latest data from prod and we imported and restored all the databases (Ax, AXmodel, Baseline) and even the Reports databases.
The data is there, Database sync works, but now we have user-based issues.
Issues:
- one of the administrator accounts can no longer log on to microsoft dynamics, even if we import it again from AD
- another normal user but with administrator rights in ax receives all kinds of errors regarding "The record cannot be modified because it has not been selected"
Good part: the main administrator can use ax without issues. (even with a different user password)
Question:
Do we have to delete some caches or import the master database from SQL server?
We tried to restore the master db, but we couldn't restore it because it doesn't recognize the single-user mode.
I guess that some unknown service (we closed all sql services from the manager) is faster than my cmd run of sqlservr or our method/commands are wrong.
Any help is appreciated
