SQL Server – v 2019 – CTP ( CTP 3.2 ) 

Background

Returned to playing around with SQL Server 2019 Community Technology Preview
( CTP ) this week.

Issues

Ran into issues such as :-

  1. Client
    • SQL Server Management Studio ( SSMS )
  2. Engine
    • SQL Server Engine
      • Error :- Msg 155, Level 15, State 1, Line 61
        …. is not a recognized… option

 

Client

SSMS

Issue

There were several issues that I ran into with trying to use SSMS v2017 with SQL Server 2019.

Resolution

Artifact

Download SSMS v 18 :-

Download SQL Server Management Studio (SSMS)
Link

Version

The current version is SSMS 18.2

artifact.SSMS.v18.2.PNG

Engine

Outline

  1. Review Current SQL Server
  2. If not latest, upgrade to latest
    • Upgrade SQL Server v 2019
      • Download latest v 2019
      • Upgrade to latest v2019
      • Restart Machine
      • Validate SQL Server post reboot

Tasks

Get Version for Current SQL Server Engine

SQL


select [@@version] = @@VERSION

Output

Output – Image

@@version_ctp_2.3.PNG

Output – Textual

Microsoft SQL Server 2019 (CTP2.3) – 15.0.1300.359 (X64) Feb 15 2019 23:50:43

 

Upgrade SQL Server Engine

v 2019 – Artifact

2019 CTP is available here.

artifact.engine.v2019.ctp.3.2

v 2019 – Download Binary

Downloaded the latest v 2019 CTP

v 2019 – Install

Please initiate the upgrade by running the executable

v 2019 – Steps

Outline
  1. Installation Screen
    • Upgrade from a previous version of SQL Server
  2. Upgrade
    • Upgrade Rules
      • Warnings
        • SQL 2019 minimum CTP for Upgrade and Side by Side Support
    • Select Instance
      • v2019
        • Choose one of the SQL Server 2019 instances
          • Version Number for 2019 will have 15.0.mm.nn
            • Ours is marked 15.0.1300.359
    • Select Features
      • All previously installed features are auto-selected
    • Chose to continue upon each new selection
    • Error
      • Review Errors
        • The specified service has been marked for deletion.
          • Tracked logs for service name
            • Checked Event Viewer
            • Checked Error Log
    • Operations Pending
      • One or more files have pending operations
    • Exited Install
    • Rebooted machine
Images
Image – Installation

installation_upgrade_01_20190726_0429PM.PNG

Image – Upgrade Rules

installation_upgradeRules_02_20190726_0434PM.PNG

Image – Select Instance

installation_selectInstance_03_20190726_0435PM.PNG

Image – Upgrade
Image – Upgrade- Error

SpecifiedServiceHasBeenMarkedForDeletion.01.20190726.0740AM.PNG

Image – Upgrade – Textual

TITLE: Microsoft SQL Server 2019 Community Technology Preview 3.2 Setup
The following error has occurred:
The specified service has been marked for deletion.
Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

Image – Complete

operationsPending.01.20190726.0747AM.PNG

Rebooted Machine

Validated SQL Server Instance

Revisit – Get Version for Current SQL Server Engine

SQL


select [@@version] = @@VERSION

Output

Output – Image

@@version_ctp_3.2.02.20190726.1023AM.PNG

Output – Textual

Microsoft SQL Server 2019 (CTP3.2)  – 15.0.1800.32 (X64) Jul 17 2019 21:29:33 Copyright (C) 2019 Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

Summary

Thankfully SQL Server v2019 Customer Technology Preview continues to go on and gain steam whether we customers are paying attention or not.

It is only when we read about a new feature and desire to take it to the Lab, do we find out we need to upgrade.

CTP 3.2 was released on July 17th; about 9 days ago.

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s