How to install SQL Server 2022 step by step

By:   |   Updated: 2022-07-12   |   Comments (6)   |   Related: More > SQL Server 2022


Problem

SQL Server 2022 is the latest version of SQL Server, designed to be more integrated with Azure. This new version contains several new features and, in this tutorial, we walk through the SQL Server 2022 the installation process.

Solution

In this tutorial, we will show how to install SQL Server 2022 step by step. At the time this tutorial was written, SQL Server 2022 was at version CTP 2.0.

Prerequisites

  • At least 1 GB of memory
  • At least a super VGA 800X600 monitor or better
  • An internet connection
  • At least Windows 10 or Windows Server 2016 operating system

Download and Install Microsoft SQL Server 2022

You can download the installation file from Microsoft.com: SQL Server 2022 Preview Download and you can select "Download the EXE".

SQL Server 2022 Preview download

Once downloaded the installation wizard has 3 options:

  • Basic - Install SQL Server with the default options
  • Custom - This option allows you to select the components to install
  • Download Media - This option allows you to download the installer and run the install later

For this article, we will use Custom.

SQL Server installation types

Next, the installer will ask where to save the download. Once selected press Install.

SQL Server Evaluation Edition media location

This will download and run the install package.

Downloading SQL Server 2022 installer

The SQL Server Installation Center will open after the download completes and on the Installation page, we have the following install options:

sql server 2022 installation center
  1. New SQL Server stand-alone installation or add features to an existing installation
    • SQL Server Installation
  2. Install SQL Server Reporting Services
    • Install Reporting Services
  3. Install SQL Server Management Tools
    • Install SQL Server tools
  4. Install SQL Server Data Tools
  5. New SQL Server failover cluster installation
    • Install a new node in a failover cluster used for high availability
  6. Add node to a SQL Server failover cluster
    • Add nodes to a failover cluster
  7. Upgrade from a previous version of SQL Server
    • Upgrade from a previous SQL Server version

We will pick "New SQL Server stand-alone installation or add features to an existing installation".

Activation

On the next screen, you can enter a product key or use a free edition. The free evaluation edition is good for 180 days, which is what we will use.

SQL Server 2022 activation

License Terms

Read the license terms to make sure that you agree and press Next.

SQL Server License Terms

Microsoft Update

The Microsoft Update can check if there are updates. You can enable this option and Microsoft Update will check for updates. Press Next to continue.

Microsoft Update

Install Rules

The install rules window verifies possible problems during the installation. For example, the machine may not have the current .NET framework installed, or the firewall may need some ports enabled. In this example, we have two warnings. The firewall and the side-by-side upgrade warnings. You can click view detailed report for more details or on the warning link to get more info. Note, it is not recommended to install the machine on a domain controller and the .NET framework that is recommended is 4.7.2 or later.

Install rules

Windows Firewall Warning

If the firewall is enabled, you need to check if the required ports are enabled. If they are disabled, your services may not work. If you need more information about SQL Ports, please refer to this link: SQL Server Ports for Various Components. If you need more information to configure the firewall, please refer to this link: Configure Windows Firewall to Work with SQL Server.

Rule Check Rules

Side By Side Support Warning

The side-by-side support indicates that this upgrade is not supported for this version of SQL Server.

Rule SQL Server upgrade

Feature Selection

The feature selection includes several options as shown below.

SQL Server Feature Selection
  • Database Engine Services
    • Main component of SQL Server
  • SQL Server Replication
    • Replicate data to different databases or SQL Servers. For more information, please refer to this replication article.
  • Machine Learning Services and Languages Extension
    • Run R and Python in your SQL Server database
  • Full Text and Semantics
    • Search large sets of text in the database. This is a powerful search service that can improve performance when searching text data.
  • Data Quality Services
    • Fix, enrich, standardize and check your data.
  • PolyBase Query Service
    • Integrate Big Data Hadoop solutions with SQL Server
  • Analysis Services
    • Service for SQL Server OLAP solutions
  • Data Quality Client
    • Manage and handle data quality
  • Integration Services
    • Import and export data with custom workflows. You can use the Scale Out Master or the Scale Out Worker. These configurations are related to the package execution work process and optimize the execution.
  • SQL Client Connectivity SDK
    • Additional tools for connectivity to SQL Server
  • Master Data Services
    • Centralize and manage similar data across your databases
  • SQL Server Extension for Azure
    • Additional extensions that can be used for Azure

Instance Configuration

In the instance configuration, we enter a name to be used for the SQL Server instance. In this example, I am creating a new database engine with the instance name of instance2022, because I already have a default SQL Server instance.

Create SQL Server instance

Server Configuration

The server configuration allows creating or adding service accounts for the different services used by SQL Server. You can use the defaults or create new accounts with custom security and passwords to run the services.

server configuration

Database Engine Configuration

The database engine configuration allows you to configure several parts of the installation.

Database Engine Configuration
  • Server Configuration
    • Select the type of SQL Server authentication mode to connect the instance, either mixed mode or Windows authentication. You can also add accounts that should have complete access to SQL Server.
  • Data Directories
    • Define the location of the data directories.
  • TempDB
    • Setup your TempDB configuration here.
  • MaxDOP
    • MaxDOP is important to have a good performance. For more information, please check out this MAXDOP settings article.
  • Memory
  • Filestream
    • FILESTREAM is used to store files outside of the database like videos, PDFs, Word files, Excel files, and others.

Ready to Install

Once everything is configured, you can check the configuration and press the Install button to continue.

Ready to install SQL Server

Complete

If everything is successful, MS SQL Server 2022 will be installed, and the relational database management system is ready for use.

Complete SQL Server installation
Next Steps

The next step is to connect to SQL Server and begin working on SQL database development and administration. To do that, you should download Microsoft SQL Server Management Studio (SSMS).  Check out these resources to get started:

Here are some other SQL Server 2022 articles:



sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

View all my tips


Article Last Updated: 2022-07-12

Comments For This Article




Friday, April 14, 2023 - 2:48:11 AM - Koen Verbeeck Back To Top (91106)
Hi Daniel,

from the screenshots it seems you were installing SQL Server 2022 CTP2.0.
However, in the final version, it seems there are less features to choose from in the installation. (see screenshots in this blog post https://sqlkover.com/how-to-install-sql-server-2022/).
For example, client connectivity SDK is missing. Maybe the tip can be updated with recent info?

Regards,
Koen

Friday, December 2, 2022 - 12:38:51 AM - Austen Back To Top (90744)
Thanks for this guide! Real solid. I install SQL Server so infrequently that I always forget what to do...

Wednesday, October 19, 2022 - 4:35:49 AM - Daniel Back To Top (90616)
Thanks for the detailed instructions — I could quickly install SQL Server 2022 using it. By the way, I was happy to learn that my favorite SQL manager supports integration with the latest version.

Wednesday, July 27, 2022 - 3:34:57 PM - Aubrey Back To Top (90313)
Daniel,

Good article, short and to the point.
Just a heads up to the newbie that might be trying to install this on their local machine.
In the step "Database Engine Configuration", the user needs to click on the "Add Current User" button before preceding to the next step.

Thanks.

Monday, July 18, 2022 - 5:03:05 PM - Greg Robidoux Back To Top (90279)
Hi Matt, thanks for the input.

I was able to install SQL 2019 and SQL 2022 CTP 2.0 on the same VM and both are working.

-Greg

Monday, July 18, 2022 - 4:04:56 PM - Matt Fuerst Back To Top (90278)
Possibly of importance to your readership is that the 2022 Preview is not able to be installed side by side with an existing SQL Server instance. (At least that was the case when I was testing it in early 2022.) So you have to have a dedicated machine that doesn't have SQL Server installed on it. (Which for me meant spinning up a new VM to play around temporarily.)