How to add database in Dynamics NAV Development Environment

(0) Share

Report

Posted on by Lovisa LH

Hello all!

I want to use Microsoft NAV Development to create queries, and to add fields to pages (as helpfully advised by Zhu here community.dynamics.com/.../how-to-add-column-in-posted-purchase-invoice-list)

I have downloaded NAV Development Environment, my problem is that if I try to add new database via File, Database, New (or via File, Database, Open) I select Server Name and there are no names in the Available Microsoft SQL Servers

Can anyone advise me next steps?

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

Here is one way: docs.microsoft.com/.../new-navdatabase

Most common is through SQL MS: archerpoint.com/.../

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (0)

Report

Hi, first you need to add your test database to SSMS. If you choose the Demo environment during installation, this database will be added automatically.

For example:

Then open your development environment, choose File -> Database -> Open...

Select the server name,

You can find this info from ssms.

And select Authentication method. Windows or Sa.

Finally, you can select Database.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Lovisa LH 29 on at

Like (1)

Report

Thank you very much Zhu! Now I will work on your previous suggestions :-)

Was this reply helpful? Yes No