Creating Super User in NAV 2016 using SQL Query
Get the SID of the current user login
Open the command prompt.
Type the following command and click enter to get the SID of current user login:
Get SID of all users in the domain
Type the following command and click enter to get the SID of all the domain users:
wmic useraccount get name,sid
Run the query in SQL
Open Microsoft SQL Server Management Studio.
Right-click on the database in which you would like to create the user and select New Query.
Copy the following query and paste it in the New Query window:
NOTE: Make sure to replace <Domain Name>, <User Name> and <SID> with correct information.
|DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50)
SET @USERNAME =
SET @USERSID =
SET @WINDOWSSID =
[Windows Security ID],[Change Password],[License Type],[Authentication Email],[Contact Email])
Click Execute, to run the query.
After successful execution, the specified user is created in the database. Please check Users page in NAV.