Some changes in SQL Server 2016 Setup

Today I’ve installed SQL Server 2016 on a Windows Server 2012 R2 machine. Some things are changed  compared to the SQL 2014, SQL2012 and SQL 2008 R2 setups. A few changes:

1. You don’t need to install the .NET Framework 3.5 prerequisite anymore. Instead it installs the .NET Framework 4.6 automatically if it isn’t installed yet. In previous setups (SQL 2014, SQL 2012 and SQL 2008 R2) you first needed to install the .NET Framework 3.5 manually.
2. During setup it’s now possible to Grant the ‘Perform Volume Maintenance Task’ permission to the SQL Server database engine:

Grant Volume Maintenance Task privilege during SQL 2016 Setup

3. On the database engine configuration you now have the option to configure the tempdb data- en logfile:

TempDB Settings during SQL 2016 Setup

4. Installing the ‘SQL Server Management Studio’ isn’t an installation option anymore. If you want to install it you must download it from Microsoft manually. Download SQL Server 2016 Management Studio.

SQL Server Management Studio 2016

 

Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2

Since the release of NAV 2013 R2 in october 2013 Microsoft has released a lot of Cumulative updates for this version. Below you can find a list of all the releases until june 2016:

Hotfix version Release date Build number
Cumulative Update 32 for Microsoft Dynamics NAV 2013 R2 June, 2016 46057
Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 May, 2016 45822
Cumulative Update 30 for Microsoft Dynamics NAV 2013 R2 April, 2016 45478
Cumulative Update 29 for Microsoft Dynamics NAV 2013 R2 March, 2016 45254
Cumulative Update 28 for Microsoft Dynamics NAV 2013 R2 February, 2016 44970
Cumulative Update 27 for Microsoft Dynamics NAV 2013 R2 January, 2016 44366
Cumulative Update 26 for Microsoft Dynamics NAV 2013 R2 December, 2015 43896
Cumulative Update 25 for Microsoft Dynamics NAV 2013 R2 November, 2015 43391
Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 October, 2015 42950
Cumulative Update 23 for Microsoft Dynamics NAV 2013 R2 September, 2015 42610
Cumulative Update 22 for Microsoft Dynamics NAV 2013 R2 August, 2015 42221
Cumulative Update 21 for Microsoft Dynamics NAV 2013 R2 July, 2015 41768
Cumulative Update 20 for Microsoft Dynamics NAV 2013 R2 June, 2015 41371
Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 May, 2015 40941
Cumulative Update 18 for Microsoft Dynamics NAV 2013 R2 April, 2015 40452
Cumulative Update 17 for Microsoft Dynamics NAV 2013 R2 March, 2015 40076
Cumulative Update 16 for Microsoft Dynamics NAV 2013 R2 February, 2015 39665
Cumulative Update 15 for Microsoft Dynamics NAV 2013 R2 January, 2015 39354
Cumulative Update 14 for Microsoft Dynamics NAV 2013 R2 December, 2014 38801
Cumulative Update 13 for Microsoft Dynamics NAV 2013 R2 November, 2014 38455
Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 October, 2014 38053
Cumulative Update 11 for Microsoft Dynamics NAV 2013 R2 September, 2014 37799
Cumulative Update 10 for Microsoft Dynamics NAV 2013 R2 August, 2014 37563
Cumulative Update 9 for Microsoft Dynamics NAV 2013 R2 July, 2014 37221
Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2 June, 2014 36897
Cumulative Update 7 for Microsoft Dynamics NAV 2013 R2 May, 2014 36703
Cumulative Update 6 for Microsoft Dynamics NAV 2013 R2 March, 2014 36366
Cumulative Update 5 for Microsoft Dynamics NAV 2013 R2 March, 2014 36281
Cumulative Update 4 for Microsoft Dynamics NAV 2013 R2 February, 2014 36078
Cumulative Update 3 for Microsoft Dynamics NAV 2013 R2 January, 2014 36035
Cumulative Update 2 for Microsoft Dynamics NAV 2013 R2 December, 2013 35800
Cumulative Update 1 for Microsoft Dynamics NAV 2013 R2 November, 2013 35701

If you want to download a particular CU you need a valid Partner Source / Customer Source login. Please consult your Dynamics NAV partner first before considering to deploy a new Cumulative Update because it may cause issues with the solution from your partner for example.

Download from Partnersource
Download from Customersource

Released Cumulative Updates for Microsoft Dynamics NAV 2013

Since the release of NAV 2013 in april 2013 Microsoft has released a lot of Cumulative updates for this version. Below you can find a list of all the releases until june 2016:

Hotfix version Release date Build number
Cumulative Update 39 for Microsoft Dynamics NAV 2013 June, 2016 46056
Cumulative Update 38 for Microsoft Dynamics NAV 2013 May, 2016 45787
Cumulative Update 37 for Microsoft Dynamics NAV 2013 April, 2016 45477
Cumulative Update 36 for Microsoft Dynamics NAV 2013 March, 2016 45241
Cumulative Update 35 for Microsoft Dynamics NAV 2013 February, 2016 44969
Cumulative Update 34 for Microsoft Dynamics NAV 2013 January, 2016 44364
Cumulative Update 33 for Microsoft Dynamics NAV 2013 December, 2015 43894
Cumulative Update 32 for Microsoft Dynamics NAV 2013 November, 2015 43390
Cumulative Update 31 for Microsoft Dynamics NAV 2013 October, 2015 42948
Cumulative Update 30 for Microsoft Dynamics NAV 2013 September, 2015 42591
Cumulative Update 29 for Microsoft Dynamics NAV 2013 August, 2015 42219
Cumulative Update 28 for Microsoft Dynamics NAV 2013 July, 2015 41767
Cumulative Update 27 for Microsoft Dynamics NAV 2013 June, 2015 41354
Cumulative Update 26 for Microsoft Dynamics NAV 2013 May, 2015 40940
Cumulative Update 25 for Microsoft Dynamics NAV 2013 April, 2015 40468
Cumulative Update 24 for Microsoft Dynamics NAV 2013 March, 2015 40118
Cumulative Update 23 for Microsoft Dynamics NAV 2013 February, 2015 39671
Cumulative Update 22 for Microsoft Dynamics NAV 2013 January, 2015 39369
Cumulative Update 21 for Microsoft Dynamics NAV 2013 December, 2014 38800
Cumulative Update 20 for Microsoft Dynamics NAV 2013 November, 2014 38454
Cumulative Update 19 for Microsoft Dynamics NAV 2013 October, 2014 38052
Cumulative Update 18 for Microsoft Dynamics NAV 2013 September, 2014 37798
Cumulative Update 17 for Microsoft Dynamics NAV 2013 August, 2014 37532
Cumulative Update 16 for Microsoft Dynamics NAV 2013 July, 2014 37201
Cumulative Update 15 for Microsoft Dynamics NAV 2013 June, 2014 36919
Cumulative Update 14 for Microsoft Dynamics NAV 2013 May, 2014 36605
Cumulative Update 13 for Microsoft Dynamics NAV 2013 April, 2014 36347
Cumulative Update 12 for Microsoft Dynamics NAV 2013 March, 2014 36207
Cumulative Update 11 for Microsoft Dynamics NAV 2013 February, 2014 36076
Cumulative Update 10 for Microsoft Dynamics NAV 2013 January, 2014 36005
Cumulative Update 9 for Microsoft Dynamics NAV 2013 December, 2013 35782
Cumulative Update 8 for Microsoft Dynamics NAV 2013 November, 2013 35670
Cumulative Update 7 for Microsoft Dynamics NAV 2013 October, 2013 35488
Cumulative Update 6 for Microsoft Dynamics NAV 2013 September, 2013 35345
Cumulative Update 5 for Microsoft Dynamics NAV 2013 August, 2013 35201
Cumulative Update 4 for Microsoft Dynamics NAV 2013 July, 2013 35026
Cumulative Update 3 for Microsoft Dynamics NAV 2013 June, 2013 34902
Cumulative Update 2 for Microsoft Dynamics NAV 2013 May, 2013 34688
Cumulative Update 1 for Microsoft Dynamics NAV 2013 April, 2013 34587

If you want to download a particular CU you need a valid Partner Source / Customer Source login. Please consult your Dynamics NAV partner first before considering to deploy a new Cumulative Update because it may cause issues with the solution from your partner for example.

Download from Partnersource
Download from Customersource

NAV 2016 Administration Shell shortcut is missing

When you perform an installation of Microsoft Dynamics NAV 2016 depending on the choices you make during setup the following shortcuts will be created:

  • Dynamics NAV 2016 Administration
  • Dynamics NAV 2016 Administration Shell
  • Dynamics NAV 2016 Development Environment
  • Dynamics NAV 2016 Development Shell
  • Dynamics NAV 2016

These will be created in C:\ProgramData\Microsoft\Windows\Start Menu\Programs

However, the shortcut ‘Dynamics NAV 2016 Administration Shell’ will be installed in ‘C:\Users\Username\AppData\Roaming\Microsoft\Windows\Start Menu\Programs’

So if you login as another user you won’t find this Shortcut in your Start Menu. One workaround is to manually create the shortcut:

Create a shortcut en refer to: C:\Windows\system32\WindowsPowerShell\v1.0\PowerShell.exe -NoExit -ExecutionPolicy RemoteSigned ” & ‘ C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1 ‘ ”

A better solution would be to move ‘Dynamics NAV 2016 Administration Shell’ to the correct corresponding folder or of course if Microsoft does this already by design for you?