The User Setup does not exist. Identification fields and values: User ID= ‘Domain\UserName’.

Solution of the error while restoring the client NAV DB

Steps for resolve Above Error:

Step 1:

• Run Below Query to truncate user related tables.

        USE Database Name;

        TRUNCATE TABLE "User Personalization";

        TRUNCATE TABLE "User Property";

        TRUNCATE TABLE "Access Control";

        TRUNCATE TABLE "User";

        GO

• Now check user table that all the records are deleted.

Step 2:

• Now, open Windows PowerShell ISE and run below script to see nav related commands.
• Set-ExecutionPolicy unrestricted -Force Import-Module 'C:\Program Files\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1'

• Please note that above script is for NAV 2015 you can check your C drive path and change as per your version.
• Now click on the Refresh button to see NAV commands.

• Now you can search in Name textbox to see that all the NAV commands are visible or not.

Step 3:

• We can create NAV user ID via Power Shell commands as below command.
• Select New-NAVServerUser Command and fill the textboxes as below screenshot.

• Click on Run button after filling all the details.

Step 4:

• Assign new Permissions to newly created user, To assign permission to above created user Select New-NAVServerUserPermissionSet Command and fill the textboxes as below screenshot.

• Click on Run button to complete process.

• Now check in the SQL DB that new user is created or not?

Step 5:

• Please don’t consider that all the steps are completed now last and main steps is remain in that we need to add user in User Setup table from backend.
• Select the User Setup table of the company which you want to open from RTC. Right click and select Edit Top 200 rows, now copy your User ID from User table.

Step 6:

• Restart your NAV Server Instance and check that your server instance selected login account as Network Service.
• RUN the RTC. That’s it!!!