“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 !