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]

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. 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

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 !

Advertisements

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...