Dynamics NAV - Access is denied, you do not have access to this company after restoring a backup from anoter NAV server - How to login to any NAV company

Run this to clear all current user settings

delete from [dbo].[User]

delete from [dbo].[Access Control]

delete from [dbo].[User Property]

delete from [dbo].[Page Data Personalization]

delete from [dbo].[User Default Style Sheet]

delete from [dbo].[User Metadata]

delete from [dbo].[User Personalization]

Ensure that your NAV instance is pointing to the correct database
Restart NAV instance
Right click on NAV and run as administrator
You should get into the company
Add your user and set it as SUPER