27 Feb’17

Dynamics NAVCreating a new database in NAV 2017


Generally, when we install NAV, a default Demo database is always created in the Microsoft Dynamics NAV Development environment. In this blog, a new database is created thus, the developer can use two or more databases in a single NAV Development environment.


1. Microsoft Dynamics NAV Development Environment
2. Microsoft SQL Server Management Studio.


  1. In the Microsoft Dynamics NAV Development environment, Click on file then database and New. A new window opens, enter the database name of your choice and then click on OK.
  2. This creates a database with limited number of table objects starting from number 2000000004 i.e Permission set.
  3. Here Upgradation Database is the name of the Database

  4. Open the Microsoft SQL Server Management Studio as Administrator, navigate to the Demo datebase then navigate to Tasks and select Backup
  5. A new window opens, and click on Add button to specify the backup path
  6. Click on the button highlighted in the above screenshot, a new window opens, locate the database file and specify the file name and then ok. This will take the backup of the specified database.
  7. Now go to the new database created, in this example the database name is ‘Upgradation Database’. Navigate to task then restore then database.
  8. Now select device radio button in the source, click on the Assit edit button. Select the folder and select type as All Files.
  9. Select the Option and check the overwrite and close existing connection to destination database and then click on OK.
  10. Thus, using the above given steps a new database is created with all the standard objects.
  11. To access this database from the front end we need to create a server instance in Dynamics NAV Administrator and link it to the newly created database.
  12. In the Microsoft dynamics NAV Administrator, right click on the Microsoft dynamics NAV(Local) and select Add Instance. Here Specify the Server Instance name and enter the unique port numbers and click on OK. This creates the server instance.
  13. Now to link it to the database, click on the server instance, click on the edit button and scroll to Database fast tab. Specify the Database name and click on save.
  14. Now Click on stop and start the services for the Microsoft Dynamics NAV server instance.
  15. Open Microsoft Dynamics NAV 2017 front end and click on select server and specify the server instance address and click on tab, the available companies will be displayed then click on OK.


Written by

Team Member


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more