Dynamics NAV login error "There is no company in the database. Contact your systems Administrator "/"You do not have the following permissions on TableData profile:Read"

Hello reader. This is my first blog in 2020 so Happy New Year. You are welcome. My colleague ran into a nasty error that took us sometime to resolve. Our client reported a problem so we needed to take a back up so we run it on our PCs for trouble shooting

However, upon restoring the database, and running Dynamics NAV 2018. It would throw this error on the screen.

Trying to run NAV 2018 in configuration mode (Via command-line ) now throws this error

To work around this issue, simply create a new user in Dynamics NAV power shell.

Give the new user super permission set.

To learn how to add users using power shell click here

Cheers!!