Saturday, July 11, 2015

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

The installation of SQL Server 2016 CTP 2.1 did not proceed to completion and it got blocked during the features rule checking and a error message was displayed.


Upgrade 16

This post describes the problems and fixes that led to successful installation.
tip: If the installation stops there is no need to cancel the installation. Just leave it as is and correct the problem.

As the message was related to SQL Server Analysis Services it was assumed that it had problems starting. It was correctly surmised that it could have been due to some authentication failure. Since there was a password update in the past couple of dates, the password for the SQL Server Analysis Services for the CTP 2.0 was updated. The SQL Server Analysis Services was restarted successfully after the password change.

It may be recalled that during SQL Server installation each of the installed components can get their own authentication.

After this the CTP 2.1 installation was continued (you can use the back button to go a step(s) backwards). The Ready to Upgrade window appeared as shown.

Upgrade 18.png

Clicking Next takes you to the Upgrade Progress window as shown. The CTP 2.1 really takes a long time at this step.

Upgrade 19.png

Again there was another hiccup as there was another SSIS related problem.

Upgrade 21.png

Again the installation was not stopped or cancelled. It was left in that position.

The same assumption was made for the SQL Server Integration Services as well. The password was corrected in the Control Panel|Services. The retry button on the error message was activated.

The installation completed and the computer needs a restart.


Upgrade 23.png

After restarting the install log was checked and verified.
------------
Feature:                       Management Tools - Complete
  Status:                        Passed
  Feature:                       Client Tools Connectivity
  Status:                        Passed
  Feature:                       Client Tools SDK
  Status:                        Passed
  Feature:                       Client Tools Backwards Compatibility
  Status:                        Passed
  Feature:                       Management Tools - Basic
  Status:                        Passed
  Feature:                       Reporting Services - Native
  Status:                        Passed
  Feature:                       PolyBase Query Service for External Data
  Status:                        Passed
  Feature:                       Database Engine Services
  Status:                        Passed
  Feature:                       Data Quality Services
  Status:                        Passed
  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Passed
  Feature:                       SQL Server Replication
  Status:                        Passed
  Feature:                       Master Data Services
  Status:                        Passed
  Feature:                       Distributed Replay Client
  Status:                        Passed
  Feature:                       Distributed Replay Controller
  Status:                        Passed
  Feature:                       Integration Services
  Status:                        Passed
  Feature:                       Data Quality Client
  Status:                        Passed
  Feature:                       Analysis Services
  Status:                        Passed
  Feature:                       Reporting Services - SharePoint
  Status:                        Passed
  Feature:                       Reporting Services Add-in for SharePoint Products
  Status:                        Passed
  Feature:                       SQL Browser
  Status:                        Passed
  Feature:                       Documentation Components
  Status:                        Passed
  Feature:                       SQL Writer
  Status:                        Passed
  Feature:                       Setup Support Files
  Status:                        Passed

The SQL Server Management Studio for the CTP 2.1 is the following (although it is still the SSMS 2016):


 Upgrade24_SSMS