SQL Server 2022 installation

SQL Server 2022 overview and installation

Feature highlights

The following sections identify features that are improved our introduced in SQL Server 2022 (16.x).

• Analytics
• Availability
• Security
• Performance
• Query Store and intelligent query processing
• Management
• Platform
• Language

You can upgrade from SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), SQL Server 2017 (14.x), and SQL Server 2019 (15.x). 

For other deployment scenarios, see:

• Linux
• Docker containers
• Kubernetes - Big Data Clusters (SQL Server 2019 (15.x) only)

Once the download is complete, click on SQL2022-SSEI-Dev file and you get below options for the installation of SQL 2022. 

      It gives three options to choose:

1. Basic: To install the database engine with default settings.
2. Custom: in this option, we will go through the installation steps and configure SQL Server as per our requirement.
3. Download Media: If we just want to download the set up, choose this option. We can choose ISO\CAB format to download.  
   

Let us choose the Download Media for the installation. Once you click on the Download Media, it asks for the SQL Server media download target location. This path should have sufficient free space to download media.

You will get ISO file on your download path.  Mount the ISO file.  And click setup file.

It launches the SQL Server installer page that contains links for below pages:

• Planning    : for SQL Server documentation, release notes, upgrade documentation etc.
• Installation: Install SQL Server services on stand-alone and cluster instance; install SQL Server Reporting service, Management tools, data tools etc.
• Maintenance: Edition upgrade, repair, remove a node from clusters.
• Tools: System configuration checker, SQL Server feature discovery report, Microsoft Assessment and Planning Toolkit
• Resources: SQL Server resources, books online, license agreement, privacy statement.
• Advanced: install SQL Server on the configuration file, advanced cluster preparation, image preparation and completion of the standalone instance
• Option    : Specify architecture (x64 or x86) and installation media root directory.

Click on Installation page and then on ‘New SQL Server stand-alone installation or add features to an existing installation’

    

    click Next

Accept the license terms and conditions. Please note the message written here that SQL Server

Transmits information about installation experience in performance data to Microsoft to help improve the product. click Next

Click on Next. In the next page, it checks for the Global rules and give status information about successful, failed rules. If there are any failed rules, we need to fix those before proceeding with the installation.

In the next step, it downloads the setup files. If SQL Server installation is already there on the server, it might skip the steps.

In the next screen, it checks for setting up rules that might cause issues in the SQL Server installation. We can see the warning message against the Windows Firewall but it can be ignored. Click next to move further.

Now we need to select the features, we need to install with this installation. 

You can choose to install a default or named instance name. If a default instance is already present on the machine, we can only install named instance. Provide an appropriate name for the named instance. For example, I specified SQL 2022.

In the next page, Server configuration, you can specify service account to use for SQL Server services along with the Collation. In this article, let us move with default service account and collation. We can change service accounts later from SQL Server configuration manager.

If we want to change the collation, click on customize and choose the required collation. We need to be cautious while changing Collation.

Specify Authentication modes (Windows or Mixed mode) and add users to have SQL Server administrators.

Click on Data Directories and we can specify the data, log files, backup directories here.

Click on TempDB to configure the TempDB configurations. We will move with the default configuration suggested by the installer.

Click on MaxDOP to configure the MaxDOP configurations. We will move with the default configuration suggested by the installer.

Click on Memory to configure the Memory configurations. We will move with the Recommended configuration suggested by the installer.

We get an overview of the SQL Server configurations from the Ready to install page. Review the information and click on next to start the installation process.

Once the installation is completed, launch SSMS 18.0 preview to connect with SQL Server.

Download and install SSMS Release 18 Preview 4

We need to install SSMS 20.0  to connect to SQL Server 2022 and explore full features. To install SSMS 20.0 Download from Link 

Download the SSMS release 20.0 and start the installation. It just completes without any user input.

It gives below message to restart the system to complete setup.

Now launch SSMS and connect to SQL Server to check the version and edition details.

Connect to the instance.

Conclusion

SQL Server 2022 does indeed seem like an exciting release, offering a range of new features and improvements that can benefit users in various ways. Exploring these features further will likely provide insights into how they can enhance database management and performance. If you have any specific areas or features, you're particularly interested in, feel free to dive deeper into them for a more comprehensive understanding.