NAV 2015, “How-to” solve “You are not authorized to sign in..” error

NAV 2015, “How-to” solve “You are not authorized to sign in..” error

How to login in “any database”
Follow this and you can login in any database (delete ALL existing configuration and can login)
Source Waldo Blog  http://dynamicsuser.net/blogs/waldo/archive/2012/12/05/nav-2013-how-to-log-in-any-database.aspx
By SQL Script > Grant SUPER to Role ID in Access control table
There are 2 ways for your case, run SQL script on your database:
1. Come back to no user as before you create the user:
DELETE [Access Control]
DELETE [User]
2. Set all users as SUPER users:
UPDATE [Access Control] SET [Role ID] = ‘SUPER’
Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485
by “PowerShell”, nice RESCUE Solution
1. Start the NAV 2015 Administration Shell or Powershell ISE
2. Execute the command:

1. New–NAVServerUser –ServerInstance YOURINSTANCENAME –WindowsAccount YOURUSERACCOUNT

(of course replace the ‘YOUR…’ with your data :D  ; probably YOURINSTANVCE should be: DynamicsNAV80 )
3. Execute the command:

1. New–NAVServerUserPermissionSet –ServerInstance YOURINSTANCENAME –WindowsAccount YOURUSERACCOUNT –PermissionSetID SUPER

Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485

NAV MSDN Bible
You can find info on assigning permissions here: https://msdn.microsoft.com/en-us/library/dd338839(v=nav.80).aspx
And also general info on creating users here: https://msdn.microsoft.com/en-us/library/dd355093(v=nav.80).aspx
Source https://community.dynamics.com/nav/f/34/p/166672/408485#408485

Have Fun