
How to create a new Dynamics NAV User from PowerShell
Current Windows User must have admin permission to the SQL Server

You may have many experiences where you were in need of killing a NAV Application Server or NAV Service Tier Windows Service which has been stuck at stopping. Basically, you may have wanted to get this done without needing to reboot a server in the middle of the day.
You may have many experiences where you were in need of killing a NAV Application Server or NAV Service Tier Windows Service which has been stuck at stopping. Basically, you may have wanted to get this done without needing to reboot a server in the middle of the day.
Here’s what you need to do:
Step 1. Find out the Service Name
To do this, go in to services and double click on the service which has stuck. Make a note of the “Service Name”.
Step 2. Find out the PID of the service
Open an elevated command prompt and type in:
sc queryex servicename
Make note of the PID
Step 3. Kill the PID
From the same command prompt type in:
taskkill /f /pid [PID]
Be careful of what you are killing though. If you kill a critical windows service you may end up forcing the machine to reboot on it own.

Premanath Kumarage
Author

Current Windows User must have admin permission to the SQL Server

By default which database to connect is stored in a config file called ClientUserSettings.Config file.

Table locking is a normal but often confusing reality in any multi-user ERP system. In Microsoft Dynamics NAV, locking issues are especially common in manufacturing and service-based organisations, particularly during month-end processing.
Start here
A working session, not a sales call. Bring the process your current system fights you on, and we will tell you plainly what it would take to fix it.
Newsletter
Stay ahead with Microsoft Business Applications.
Insights, implementation advice and practical ideas to help your business get more from Microsoft technology.
By subscribing, you acknowledge MicroCloud 360’s Privacy Policy.