If you are consultant on Dynamics NAV, and you work for a customer that use Dynamics NAV, so you may be want to test or configure any scenario on their database, so you have a SQL Backup of the client database and want to restore it on your own machine.

This error happen after restore backup of the SQL and try to connect to the client database using Microsoft Dynamics NAV 2018.

“You Don’t have access to Microsoft Dynamics NAV, Verify that you have been set up as a Valid User in Microsoft Dynamics NAV.


This is because you are not registered in this database as a valid user, so it was very helpful to run the below code in SQL database to remove all the users in Dynamics Database and be able to access the application. And it works properly and i am able to open Dynamics NAV without this error.