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

you are not aut

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]


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. NewNAVServerUser ServerInstance YOURINSTANCENAME WindowsAccount YOURUSERACCOUNT

(of course replace the ‘YOUR…’ with your data 😀  ; probably YOURINSTANVCE should be: DynamicsNAV80 )

3. Execute the command:

  1. NewNAVServerUserPermissionSet ServerInstance YOURINSTANCENAME WindowsAccount YOURUSERACCOUNT PermissionSetID SUPER

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


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 !

Leave a Reply

Your email address will not be published. Required fields are marked *

18 + four =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enjoy this blog? Please spread the word :)

%d bloggers like this: