Skip to main content

Installation : SQL and Microsoft Dynamics Navision 2016

 Installation : SQL and Microsoft Dynamics Navision 2016

Hi folks,

This blog basically helps you to Install SQL & NAV 2016 on your machine.


STEP 1: Firstly, Install SQL Server 2019 with Express addition

· After download Install the application by right click and select Run as Administrator to .exe setup file.


  • Now, Select custom option.

  • Browse location for installation.
  • Click on install button.
  • Just wait a moment for its downloading.

  • Click on New SQL Server stand-alone installation option.

  •         Accept the license then click on Next.

  • Click on Next.

  •   Click on Next.

  •         Click on Next after completing the process.

  • Select the required features and Click on Next (Mostly required features - (1) Database Engine Services (2) SQL Server Replication (3) SQL Client Connectivity SDK). 

  •        Click on Next.

  • Click on Next => Next => Next => Next.
  • After that select Window authentication mode, click on Add Current User button and then click on next.
Note :- Here, you can also select Mixed Mode for Authentication or to set Password to Access SQL DB.

  •          Then Click on accept button and wait for a while.

  •           Then click on Next.
  •           Again click on Accept button and then click on Next.
  •           Then wait for an installation.

  •         After completing the installation click on close button.

Note:- You can also skip STEP-2 if you already installed the complete package of SQL (not Express Edition) or if you already have SSMS (SQL Server Management Studio) on your system.

STEP 2: Install SQL Server Management Studio

·         Steps to install SSMS setup:-

  •         Select location where you want to install a setup.

  •          Then click on Install button.
                    

.·         After successful installation click on close button. 

STEP 3: Download and Installation Dynamics NAV 2016  

Link for download NAV 2016 (CU 51) :- https://www.microsoft.com/en-us/download/details.aspx?id=100810

·         Steps for Install NAV 2016

  •         Double click on setup application.

·   Click on Next.

·         Click on I accept button.

  •          Select Choose an installation option.

  •          Then select Custom option.

  •          Select required options and then click on Next.

  •   Enter SQL Server Instance name which you have provided in SQL server setup.
  •   Then click on Apply.
  •   After click on apply button below screen shown.

  •          After successful installation, click on close button.



I hope this article helps you while Installing SQL and Dynamics Navision 2016.

Comments

  1. singh.bunty0820 April 2021 at 16:25

    Helpful Document for basic understanding of installation.....Keep it up Kunal

    ReplyDelete
    Replies
    1. Kunal Huria30 May 2021 at 02:21

      Thanks for your valuable feedback. Do share it across.
      Have an A+ day!! :)

      Delete

Post a Comment

Popular posts from this blog

Amount In Words in Navision / Business Central

Hi Guys, In this article, we will see how to display amount in words in Microsoft Dynamics Business Central. Here, I am taking an example of Report object  which is widely used in Navision for converting decimal amount field into words. Procedure :-  Step-1 Declare the following Global Variables :         RepCheck:  Report  "Check";         NoText:  array [ 2 ]  of   Text ;         AmountInWords:  Text ; where, (1) RepCheck is a variable of  Report DataType Named as " Check " which is 1401. (2) NoText is a variable of DataType " Text " with array Dimension value as 2 which is defined as shown above. (3) AmountInWords is a variable of DataType " Text " which will store final result of amount in words. Step-2 Now, add the following code in OnAfterGetRecord() trigger of DataItem containing that decimal field value. So in my custom Purchase Order Report, i am adding code in the Purchase Header (DataItem) - OnAfterGetRecord() trigger.   trigger  OnA
7 comments
Read more

Flow Custom field to G/L Entry and other Posted tables : From Purchase Order to Posted Purchase invoice

Hi Readers, In this blog we will see how we can transfer data from " Purchase Header" to "Purchase Invoice Header" & "G/L Entry" table in Business Central. In this example, will create "Remarks" field on Purchase Header table and after posting, flow it to Purchase Invoice Header & G/L Entry tables: Firsly, create required fields ("Remarks") in below mentioned tables by creating table extensions: Purchase Header (38) Purch. Inv. Header (122) Gen. Journal Line (81)  G/L Entry (17) For the Purch. Inv. Header table, you can just create copy the field from purchase header and paste it in  Purch. Inv. Header  table. If the field ID No. is same for that field for both the tables then you don't have to code i.e, it automatically transfer that field data from Purch. Header to Purch. Inv. Header . Step-(1)   tableextension   50104  "Purchase Header Ext"  extends  "Purchase Header" {      fields     {         
1 comment
Read more

Calculate Date : Using Date Formula and CalcDate Function in Navision/BC

 Hi Everyone, In this article we will see how we can Calculate Date by adding and subtracting No. of Days / Months based on CalcDate and DateFormula datatype. Here, I define three variables required for: (1) " No of Days " -  To define No. of Days / Months as required. You can also use these units denoted as: <Unit> = D | WD | W | M | Q | Y (D=day, WD=weekday, W=week, M=month, Q=quarter, Y=year). (2) " From Date " and " To Date "  Date type Variables to store calculated date in it. page   50103  "Date from Date Formula" {     PageType = Card;     ApplicationArea = All;     UsageCategory = Administration;     SourceTable =  Integer ;      layout     {          area( Content )         {              group( General )             {                  field( "No. of Days"; "No. of Days" )                 {                     ApplicationArea = All;                 }             }         }     }      actions     {          area
Post a Comment
Read more