ClickOnce template in Dynamics NAV 2015 still contain references to SQL Server 2012


When you deploy ClickOnce for Dynamics NAV 2015, there is an inconsistency related to SQL Server 2014 support tools. The product DVD does have SQL Server installation files in the Prerequisite Components folder:
– \Microsoft Report Viewer 2014\ReportViewer.msi
– \Microsoft Report Viewer 2014\SQLSysClrTypes.msi

The ClickOnce template to be found in the folder \ClickOnceInstallerTools\Program Files\Microsoft Dynamics NAV\80\ClickOnce Installer Tools\TemplateFiles\NAVClientInstallation.html still refers to SQL Server 2012.

The Microsoft Report Viewer 2014 and the CLR Types for Microsoft SQL Server 2014 will not be officially released until Visual Studio 2014 ships. Until that happens the partners have these two options for resolving this issue:

1. Either the partner can take the .msi files from the NAV 2015 installation media and place these on a files hare and update the ClickOnce landing page accordingly
2. Or the partner can modify the configuration file for the RTC client to load the 2012 version of the assemblies. This is done by adding the following section to the file: Microsoft.Dynamics.Nav.Client.exe.config, which is included in the ClickOnce application package. The section is:

<dependentAssembly>
  <assemblyIdentity name=”Microsoft.ReportViewer.WinForms” publicKeyToken=”89845dcd8080cc91″ culture=”neutral”/>
  <bindingRedirect oldVersion=”12.0.0.0″ newVersion=”11.0.0.0″/>
</dependentAssembly>

For an example of how to add the dependentAssembly configuration element, please refer to this page on msdn: http://msdn.microsoft.com/en-us/library/0ash1ksb(v=vs.110).aspx

For the time being, this is sufficient to deploy ClickOnce for Dynamics NAV 2015.

Kindest regards,

Marco Mels
Support Escalation Engineer, CSS
Microsoft

These postings are provided “AS IS” with no warranties and confer no rights. You assume all risk for your use. The Netherlands

Comments (2)

  1. S.Hermann says:

    Please also correct the bindingRedirect inside of "finsql.exe.config" for the "Microsoft.Dynamics.Framework.UI.Extensibility.dll".

    It still redirects to 7.2.0.0 even 8.0.0.0 is delivered.

  2. Marco Mels says:

    Hello,

    Thank you for your comment. Yes, that issue has been fixed as well and plan is to deliver solution in next rollup for Dynamics NAV 2015.

    Kindest regards,

    Marco Mels

    Support Escalation Engineer, CSS

    Microsoft The Netherlands

    These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.