NAV 2013

“HOW TO RESET” NAV “BAD” USER


 

“HOW TO RESET” NAV “BAD” USER

If you have some issues with NAV single user (ex; can’t login, permissions lost, errors on pages etc.), you can delete ALL user configuration and after recreate a new user.

Follow procedure below.

use DB

GO

1) FIRST: SELECT [User Security ID] from USERNAME

retrieve User Security ID (User ID by uniqueidentifier)

select [User Security ID] from [dbo].[User] where [User Name] = ‘DOMAINUSER1’

–> example: User Security ID output: 49089BA8-91C5-4BD2-A322-7797760736B2 (User ID by uniqueidentifier)

2) SECOND: DELETE users configuration using [User Security ID] extracted from user name

delete [dbo].[Access Control] where [User Security ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[Page Data Personalization] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Metadata] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Property] where [User Security ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Personalization] where [User SID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

delete [dbo].[User Default Style Sheet] where [User ID] = N’49089BA8-91C5-4BD2-A322-7797760736B2′

GO

NB: STOP NAV SERVICE BEFORE DELETING from SQL !!/

STOP NAV SERVER Service (you can’t delete users from SQL with NAV server active- “USER” table is locked)

3) LAST: delete user (and after recreate form NAV User Page)

delete [dbo].[User] where [User Name] = ‘DOMAINUSER1’

GO

** If you have NAV pending services, use KIll service script below:

KILLING PENDING SERVICE PROCEDURE

Kill Service Script

sc queryex MicrosoftDynamicsNavServer$ITA

result –> Service Name

Process ID : PID 10484

taskkill /PID 10484 /F

result –> process killed

Have a nice day !

Annunci

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