Background

In the last 3rd of 2022, SQL Server 2022 will be released.

RC0 for MS Windows came out a few weeks ago.

RC0 for Linux was released a few days ago.

So the drumbeats is definitely tapping.

 

SQL Server 2022 – RC0

Installation Artifacts

Kick Starter

Outline

1. To sign up for SQL Server 2022, please go here
   • SQL Server 2022 Preview now available
     Link
2. Once you fill out your information, you will be taken here
   • Please select your SQL Server 2022 Preview download
     Link
3. On Premise or Azure
   • On Premise
     • Exe Download – 64bit
     • Please download the Kickstarter

Images

Please select your SQL Server 2022 Preview Download

 

Download Kick Starter

 

 

Installation Media

Outline

1. Select An Installation Type
   • Basic
   • Custom
   • Download Media
2. Specify SQL Server Installer Download
   • ISO
   • CAB

Images

Select An Installation Type

Specify SQL Server Installer Download

 

Download Media

Download Media -01

 

Download Media -02

Download Media -03

Download Successful

 

Installation

1. Installation File
   • You will have an ISO or CAB file
   • In our case, we have an ISO
     • The file’s name is SQLServer2022-x64-ENU.iso
   • Please mount the ISO
2. SQL Server Installation Guide
   • Installation
     • Upgrade from a previous version of SQL Server
       • In our case we already have SQL Server v2019 installed
       • We will like to upgrade in place
3. Upgrade to SQL Server 2022 RC0
   • Edition
     • Specify a free edition
       • Evaluation Edition
       • Developer Edition
       • Express Edition
     • Enter the product key
   • License Terms
     • Please agree to the License Terms
   • Product Updates
     • Error
       • Sql Server Could Not Search for updates
       • Error 0x8024402c
   • Upgrade Rules
     • Upgrade Rules –  Rule – “Machine Learning Server Shared Feature Support” generated a warning
   • Select Instance
     • Please select the SQL Server Instance you will like to target for upgrading
   • Select Feature
     • As we are upgrading, we will not be able to selectively choose which components to upgrade
   • Instance Configuration
   • Server Configuration
     • Review Service Accounts and Startup Mode
   • Full Text Upgrade
     • Option
       • Import
       • Rebuild
       • Reset
   • Ready To Upgrade
   • Upgrade Progress
   • Upgrade Complete
     • One or More affected files have operations pending. You must restart your computer after the setup is completed.
   • Restart Computer

Images

Mount an Image

SQL Server Installation Center

Edition

Edition – Free Edition – Evaluation

Edition – Free Edition – Choose Edition

Edition – Free Edition – Developer

 

License Terms

Product Updates

 

Upgrade Rules

Upgrade Rules –  Rule – “Machine Learning Server Shared Feature Support” generated a warning

Select Instance

Select Feature

Instance Configuration

Server Configuration

Full Text Upgrade

Full Text Upgrade – Option – Import

Full Text Upgrade – Option – Rebuild

Ready To Upgrade

Upgrade Progress

Ready To Upgrade -01

Ready To Upgrade -02

Ready To Upgrade -03

Complete

Validation

Outline

1. Get SQL Server Version

Tasks

Get SQL Server Version

Command

print @@version

Output

Image

Textual

Microsoft SQL Server 2022 (RC0) - 16.0.900.6 (X64) 
	Aug 20 2022 12:55:47 
	Copyright (C) 2022 Microsoft Corporation
	Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19042: ) (Hypervisor)


Completion time: 2022-09-10T06:41:19.7161441-07:00

Explanation

1. Version:- Microsoft SQL Server 2022 (RC0) – 16.0.900. (x64)
2. Release Date:- 2022-August-20th 12:55:47
3. Edition:- Developer
4. OS:- Windows 10 Enterprise

Summary

Had a few knots.

Thank God they were consistent and easily addressed.