Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Noreen Fujita-Sacco]

We’re exploring options to store our old NAV 2009 database for a couple of years after we go live with 2018 and prefer not to need SQL. This copy would be for staff to look up old data such as comments or other customer info for those we choose not to bring into 2018. Security would be easiest if it’s Classic Client on a hostserver. Can I put a local copy of NAV with database authentication on a hostserver shared drive? Thanks!

——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————

[Jason Wilder]

A little confused, are you suggesting converting back from SQL to proprietary Cside database for your 2009 database?

Not too big of a deal to just have sql server and the NAV client installed on same machine and then have people go in through remote desktop when they need it.  That’s what we do.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Gino Pack]

We have a low usage computer with SQL standard installed on it, and users RDP to get into the old NAV2009 DB. It does not take much effort to provision a computer / old server to do that.

——————————
Gino Pack
Modern Optical International | Modern Optical International
BCUG/NAVUG Co-Chapter Leader
BCUG/NAVUG Board of Advisors
gpack@modernoptical.com
——————————
——————————————-

[Noreen Fujita-Sacco]

We’re trying to keep this old version as simple as possible and accessible on premise after we start over in the cloud with 2018. We’re also trying to keep licensing as simple and inexpensive as possible. If I use the 2009 Classic Client I hope to save the cost of SQL server license and CALs. Is it possible to load 2009 on a shared server or PC with remote access that way? Thank you, again.

——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————
——————————————-

[Geovanny Fuentes]

Yes you can backup the database restore it to the classic FDB, create the service connection and allow remote users to access it.
Nav 2009, remember to setup the proper HOST/SERVICES files as needed with proper TCP connection.
Good luck

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-

[Noreen Fujita-Sacco]

Thanks all who contributed. The final answer is SQL server is needed for 2009 with Classic Client, but it does not require an Appserver.

——————————
Noreen Fujita-Sacco
Applications Coordinator
Gear Aid Inc.
Bellingham WA
360-392-2703
noreen.fujitasacco@gearaid.com
——————————
——————————————-