I've been encountering SQL Trace Flag 4616 issues when attempting to open a NAV 2009 R2 SQL database with the latest NDT Microsoft Dynamics NAV Developer's Toolkit. I was a little taken aback being aware that from NAV 5 Sp1 latest build, Trace Flag 4616 is no longer required. However, little did I know that Microsoft have somehow failed to update the underlying compatibility support files which will enable the Tool to automatically comply with NAV 2009 SP1 to R2 Databases (SQL). Anyway, long story short, the following error Error messages were sequentially triggered when attempting to open NAV SQL database:
{"type":"block","srcClientIds":["34f5910d-6d4a-49c5-8cd9-85d06bba4cc0"],"srcRootClientId":""}
Microsoft has provided a walk-around for this issue
The latest version of the Microsoft Dynamics NAV Developer’s Toolkit (version 3.01.410) is developed for Microsoft Dynamics NAV 2009. Therefore, you need to create the Developer’s Toolkit database with Microsoft Dynamics NAV 2009 client executables.
This How To article describes how you can make version 3.01.410 of the Developer’s Toolkit work with a Developer’s Toolkit database created with Microsoft Dynamics NAV 2009 SP1 client executables.
The Microsoft Dynamics NAV Developer’s Toolkit (NDT) uses C/Front to connect to the NDT database. You can make the Developer’s Toolkit connect to a database that was created with Microsoft Dynamics NAV 2009 SP1 client executables by following these steps:
Install a Microsoft Dynamics NAV 2009 SP1 Classic client
Install the Microsoft Dynamics NAV Developer’s Toolkit version 3.01.410
Create the Developer’s Toolkit database following the instructions in the Developer’s Toolkit manual
Install C/Front for Microsoft Dynamics NAV 2009 SP1
Copy the following C/FRONT files from the C/Front installation folder to the Developer's Toolkit folder:
Note:
C/Front is by default installed in the following directory: C:\Program Files\Microsoft Dynamics NAV\60\SDK\CFRONT.
The Developer's Toolkit is by default installed in the following directory: C:\Program Files \Microsoft Dynamics NAV\Developers Toolkit
Copy the following files from the Microsoft Dynamics NAV Classic client folder to the Developer's Toolkit folder:
Note:
The Microsoft Dynamics NAV Classic client is by default installed in the following directory: C:\Program Files\Microsoft Dynamics NAV\60\Classic
The Developer's Toolkit is by default installed in the following directory: C:\Program Files \Microsoft Dynamics NAV\Developers Toolkit
You can find the Microsoft Dynamics NAV 2009 SP1 Classic client and C/Front for Microsoft Dynamics NAV 2009 SP1 on the Microsoft Dynamics NAV 2009 SP1 installation media, which can be downloaded here: Microsoft Dynamics NAV 2009 Service Pack 1 (SP1).
You can download the Microsoft Dynamics NAV Developer’s Toolkit here: Developer's Toolkit for Microsoft Dynamics NAV. Please note that access to Microsoft Partnersource is required in order to download this Tool.
via How to Use the Microsoft Dynamics NAV Developer's Toolkit with Microsoft Dynamics NAV 2009 SP1.