
How to point your Dynamics NAV Client to a specific Server Instance.
By default which database to connect is stored in a config file called ClientUserSettings.Config file.

Current Windows User must have admin permission to the SQL Server
Prerequisites:
Step1:
Run Windows PowerShell ISE as an Administrator
Step2:
Type the following command on Windows PowerShell ISE

Step3:
Create NAV Server user. This command just create a new user without any associating any permission sets
New-NAVServerUser

Step4:
Assign the request role (Super Role) for the New NAV user created using previous step.
New-NAVServerUserPermissionSet


Premanath Kumarage
Author

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.

Once the Log File has been truncated, run the below command to put it back the database into full recovery mode using below statement;
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.