Saturday, July 11, 2015

Upgrading SQL Server 2016 CTP 2 to SQL Server 2016 CTP2.1

In order to install SQL Server Management Studio June 2015 Preview, you need to install the recently available SQL Server 2016 CTP 2.1.
As I had SQL Server 2016 CTP 2, I decided to upgrade the version instead of removing the previous version and installing the latest version. The installation was on a Toshiba Laptop computer (Satellite S70 Series) running Windows 8.1. The laptop also has SQL Server 2012 and SQL Server 2016 CTP2 installed.
This post is about the upgrading of the version from the SQL Server Installation Center that accompanies every version of SQL Server.

SQL Server 2016 CTP2.1 is available for download from here(

Upgrade 2.png

There are three options to choose from (herein CAB was chosen). You need to register before you proceed after which you can choose one of the dozen language options.

These are the files you will be downloading:

 Upgrade 3.png

The download may take quite a bit of time depending on your Internet connection. The download folder you choose also appears to be important and you better choose the same folder where you downloaded the CTP2.

 Here follows a number of screen shots of the upgrade activity. Some of the installation steps zips through as the checking is rapid. Upgrade has fewer steps as a lot of configuration information already exists from the existing version. The first step is the SQL Server Installation Center where you choose the option, Install/Upgrade/repair etc

Upgrade 4.png 
Start with the Installation step.

Upgrade 5.png 
Choose the Upgrade option. The Product Key page appears.

Upgrade 6.png
Herein the evaluation edition (120 days limit) is chosen. Click Next.
Upgrade 7.png 
Accept license agreement and click Next. You get to the Install Set up files window.
Upgrade 8.png

You need to choose the version you are upgrading. It comes up by default and displays the CTP 2.0 version’s instance, May 2015.

Upgrade 9.png 
Click Next. You enter the Select Features window as shown and the program checks for all the installed features.
 Upgrade 10.png 
After checking all items in the original installation (before upgrading) as selected as shown.
Upgrade 11.png 
Click Next. The Instance Configuration window is displayed as shown. The Instance ID and the directories get a '300' appended automatically as shown.

Upgrade 12.png 
Click Next. This takes you to the Server Configuration step as shown. It appears changes to only two items are recommended.
Upgrade 13.png

Click Next making no changes. You are asked to choose a Full Text upgrade option from among three options. The default is chosen.

Upgrade 14.png

Click Next.  Feature Rules are checked and it appears there is a problem.

Upgrade 15.png

To be continued…here:

 Click Next.

No comments: Protection Status