Add User to NAV 2016 Using Powershell

,

This guide’s aim is to add a windows user into a Microsoft Dynamics NAV 2016 database and give them permissions using Powershell. Useful if you’ve locked yourself out of a database by adding other users before your own.

Please note that you must be on the same server that the service is run, NOT the SQL server.

1. First you must run Windows PowerShell ISE as an Administrator.

Add user to NAV 2016, run powershell ISE as Admin

2. Copy and paste this line:

import-module “C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1”
Then press the “Run Script” (Play Icon) button.

powershell running script

You will see in the below window the processes running.

Note: you can change the “90” to 80 for 2015 and 71 for 2013 R2.

3. In the command tab on the right side of the window, press “Refresh”.

In powershell refresh the command TAB

4. Type into the name bar: “NavServerUser” and you should receive the below results.

NavServerUser

New-NAVServerUser and New-NAVServerUserPermissionSet are the commands that we need.

5. Click on “New-NAVServerUser” and fill in the highlighted fields.

New-NAVServerUser

Then click on “Run”.

6. Now we must give that user Permissions so they can connect to the database.
Click on “New-NAVServerUserPermissionSet” and fill in the highlighted fields.

powershell NAV Permissions

Then click on “Run”.

Your Windows user will now have access to the database.

 

If you’d  like more information on Metaphorix’s industry specific versions of Dynamics NAV, including Construction, Manufacturing, Distribution and Service solutions get in touch!

For more great advice, hints and tips on Microsoft Dynamics NAV sign up for our newsletter below!

Your Name (required)

Your Email (required)

Comments

 

The following two tabs change content below.