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:

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

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.

 

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?