Microsoft announced a private preview of SQL Server 2022 last fall at ignite. SQL Server 2022 is the latest offering from Microsoft with performance, availability, scalability, and security. It was not available for the public to download and explore its features. You can explore the existing article SQL Server 2022 features to understand its new features and improevments.
On May 24th, 2022, SQL Server 2022 entered the public preview phase. Anyone can download, install, and explore SQL 2022 features. SQL 2022 is part of the Microsoft Intelligent Data Platform that unifies operational databases, data governance, and analytics.
The Linux SQL 2022 will be available soon. Currently, the public preview image of SQL 2022 is available on Windows. This article guides you in installing SQL Server 2022 preview.
Firstly, navigate to https://aka.ms/getsqlserver2022 and register for the free trial.
Fill out the information such as first name, last name, email id, and organization, and you get a link to download the EXE version. As shown below, the SQL Server on Azure VM image will be published later
Specify the local directory and click on Save.
Launch the SQL2022-SSEI-Eval, and it asks you to choose from the following options.
Basic: The basic option installs the SQL Server database engine with default parameters.
Custom: You can go through the installation wizard and choose the required installation steps in the custom mode.
Download Media: You can also choose to download EXE or CAB files that you can use later for installation on your choice machine.
Let’s download SQL Server 2022 ISO file. Click on download media and choose package size and directory.
The ISO file size is around 1102 MB. Therefore, downloading takes time, depending upon your network speed.
Once the download is successful, you get the following screen.
Go to your ISO directory and mount the disk to launch the SQL Server 2022 installation wizard.
Double-click on the setup files as shown below.
The SQL Server installation center looks familiar as to previous SQL Server versions. You can launch a system configuration checker to check for conditions that can prevent a successful SQL Server installation.
As shown below, In my case, it passed all global rules without any failure, warning, or skipped step.
Click on the Installation menu and New SQL Server standalone installation or add features to an existing installation.
Follow the installation wizard as per shown screenshots.
The feature selection has a new entry – SQL Server extension for Azure. The SQL Server 2022 is fully integrated with the Azure SQL Managed Instance using the link feature. It provides the integration benefit of the platform as a service (PaaS) for the disaster recovery solution.
By default, this SQL Server extension for Azure is ticked for installation. Let’s choose the Database engine service and the SQL Server extension for Azure.
Choose default or named instance. In case of default instance, enter an instance name of your choice.
You can specify the service account for SQL Server services and collation on the next page.
The database engine configuration is similar to what we saw in SQL Server 2019.
Server Configuration: I chose mixed-mode authentication and specified SQL Server administrator.
Data directories:
TempDB:
MAXDOP:
Memory:
Click Next and the installation wizard asks for your details for connecting to Azure. You can leverage Microsoft defender for cloud, AAD authentication, and Microsoft purview by linking to Azure.
We do not have any option to skip the Azure connectivity during SQL Server 2022 installation. If you click on next without specifying Azure Service Principal details, it gives the below errors:
I do not have Azure details with me at this point. Therefore, I go back to the features page and uncheck on SQL Server Extension for Azure.
Review and start the installation process of SQL Server 2022.
After the installation, launch the SQL Server Management Studio and connect to SQL Server.
Note: The SQL Server Management Studio is a standalone client tool that you can download from Microsoft docs.
We have installed Microsoft SQL Server 2022 CTP 2.0 version, as shown below. The version number is 16.0.600.9.
Stay Tuned for further tips on SQL 2022!!