You have a full backup of your customer and restore it on your server. Once the restore is finished, you have to create a user in NAV that is known on your server. THIS BEFORE getting out of NAV. But of course you have forgotten to do it and now you can’t get into your DB.
If you have done a restore in a native DB, there is no other option than to redo the complete restore.
If, on the other hand, you have a SQL DB, than there are some methods to fix it.
1. First try to login with user ’sa’. A lot of times, this user is also defined as a NAV database login.
2. If you know a NAV Database login that has superuser rights, you can just use that user in SQL.
3. Add the user you want directly into the tables of SQL
4. Another way is to delete all logins and their roles from the tables. The following sql-statements do just that:
delete from dbo.[Member Of];
delete from dbo.[User];
delete from dbo.[Windows Access Control];
delete from dbo.[Windows Login];