Showing posts with label NAV 2017. Show all posts
Showing posts with label NAV 2017. Show all posts

Friday, September 21, 2018

Dynamics NAV Idle Time Setup (Windows Client)

Dynamics NAV Idle Time Setup (Windows Client)


Hi Everyone,

Today we will demonstrate you, how to set idle time in Dynamics NAV for windows client. 
As we all understand, most of the companies need a cost effective ERP solution today and the number of license purchased by the company can be very limited. 

If any user has logged in to the system but doesn't do any work, another user will not be able to work because Dynamics NAV will give an error restricting the user log in as all licenses are in use at that time.

So the solution for this issue is setting up a maximum idle time for the client. Therefore, if any user is logged in but not using the system, the system will automatically end the session of the user.


The first step is to open Dynamics NAV 2017 Administration.

Idle Time setup - Dynamics NAV

Then you have to select the instance that is been used currently.


Idle Time Setup


The go to the client services tab --> idle time out --> Edit

Idle Time setup - Dynamics NAV




Type the time out in following format (hh:mm:ss) > Save

Example: For a time out after 15 mins of idle time, you have to set the time as below,



Once the time is set, select the server and restart the server (By clicking right button of the mouse)

Idle Time setup - Dynamics NAV

Thank you.

Have a good day. 😊

Thil.









Wednesday, September 19, 2018

SQL Authentication on Microsoft NAV Server Instance


SQL Authentication on Microsoft NAV Server Instance


Hi Allllll,

This topic describes how to configure SQL Authentication on Microsoft NAV Server Instance using Microsoft Dynamics NAV Server Administration tool.
When using SQL Server authentication, Dynamics NAV requires an encryption key to encrypt the credentials(Username and password) that the Microsoft Dynamics NAV Server instance uses to connect to the Dynamics NAV database in SQL Server. The encryption key must be installed on the computer where the Microsoft Dynamics NAV Server is installed and also in the database in SQL Server.

To do that, first you must delete the existing key file, if any. Here I am going to configure SQL authentication for the “DynamicsNAV101” instance.

1. Go to the following path and delete the relevant key file. (Here, ProgramData is a hidden folder).
C:\ProgramData\Microsoft\Microsoft Dynamics NAV\100\Server\Keys

SQL Authentication - Microsoft NAV Server Instance



2.     Open the Microsoft Dynamics NAV Server Administration tool.
click Start, enter Microsoft Dynamics NAV Administration in the Search textbox, and then choose the related link.

SQL Authentication - Microsoft NAV Server Instance

3. In the console tree, which is in the left pane, expand the node for the computer that contains the Microsoft Dynamics NAV Server instance, and then select the Microsoft Dynamics NAV Server instance.    
4. In the Actions pane, choose Database Credentials.
       5. On the Database Credentials page, click the Edit button.

SQL Authentication - Microsoft NAV Server Instance





6. Set the Database Authentication Mode to SQL Server Authentication.
7. In the Database User Name field, type the login name for the database user that you want to use to access the Microsoft Dynamics NAV application database in SQL Server.
8.  In the Password field, type the login password for the database user that you want to use to access the Microsoft Dynamics NAV database in SQL Server.

SQL Authentication - Microsoft NAV Server Instance
Add caption


      9. Click Save button, and then click OK button on the Enable Encryption on SQL Server Connections dialog box.

SQL Authentication - Microsoft NAV Server Instance


   10. On the Information dialog box about encryption, again click OK button.

SQL Authentication - Microsoft NAV Server Instance


11. Click the root of the console tree, which is in the left pane.



SQL Authentication - Microsoft NAV Server Instance


12.If the instance is  stopped, then Start it. If the instance is running then Restart it. Also make sure that the server instance is in the Running status all the time.

SQL Authentication - Microsoft NAV Server Instance




SQL Authentication - Microsoft NAV Server Instance



SQL Authentication - Microsoft NAV Server Instance


Thank you.
Chameera


How to Customize a standard report in Dynamics Business Central SaaS

Good day to you..… From this article, I am going to give a solution to a problem which I have seen most of forums. As all of you are aw...