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

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.

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.

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.

Add caption

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

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

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

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.

Thank you.
Chameera