In this article, we will visually show how to install SQL Server 2022, as well as the initial application settings that can be configured during the installation.
For a complete installation, you will need:
Download the original SQL Server 2022 installer from our website or from the official Microsoft website.
If you decide to download the installer from our website, you can immediately proceed to the installation instructions!
A product key for SQL Server 2022, which you can purchase in our store with instant delivery to your email!
1) Go to the official Microsoft website and download the SQL Server 2022 installer by clicking on “64-bit edition”.
2) Then open the downloaded “exe” file.
3) Click “Download Media”.
4) Select the installer language, and click “Download”.
5) After that, the download of the SQL Server 2022 ISO installer to your computer will begin.
1) Open the ISO file that we previously downloaded from the official Microsoft website or from our website.
2) Run the “setup.exe” file as an administrator and wait for the installer to open.
3) In the opened program, go to the “Installation” section.
4) Then go to “New SQL Server stand-alone installation or add features to an existing installation”.
5) After that, select the free “Developer” edition and click “Next”. Or if you have already purchased a product key in our store, enter it in the “Enter the product key” section.
6) Accept the license terms and click “Next”.
7) Here just click “Next” without selecting any checkbox.
8) Next, the installation of setup files will begin.
Upon completion of the installation, just click “Next”.
9) Uncheck “Azure extension for SQL Server” => “Next”.
10) Check boxes – “Database Engine Services” and “Full-Text and Semantic Extractions for Search”. Then click “Next”.
11) Leave everything as default, click “Next”.
12) In this window, you can set the startup type for any service. Set it to auto-start, manually, or disable it if you do not need this service for your tasks. In our example, we leave everything as default and click “Next”.
You can also go to the “Collation” menu — These are the encoding table settings. As well as, perform sorting, how to handle uppercase and lowercase letters, how to react to characters, etc.
13) Proceed to the account settings for connecting to SQL Server 2022. You are offered to choose between Windows authentication mode or mixed mode, i.e., the ability to log in using both Windows and SQL Server accounts. If you choose mixed mode, you will be prompted to create a SQL Server account.
In the example, we will choose “Windows authentication mode” => click “Add current user” and add it.
You can also go to the “Data Directories” tab. In this section, you can choose locations for the root directory, system database directory, user database directory, user database log directory, and backup directory. It is recommended to specify all locations on different hard drives/partitions. Ideally, the data directory should be on a separate hard drive.
In the next tab, “TempDB”.
Number of files — default based on the number of cores.
Initial size — it is recommended to increase the size to at least 16 or 32 MB.
Auto-growth — This is the amount of MB that will be added if the file is 100% full. The amount is usually specified depending on the tasks and usage of SQL Server, default is 64 MB, but it is recommended to add from 1 GB to avoid performance issues in SQL Server.
The next tab is Filestream settings — this setting allows storing files in the NTFS file system, it can be optionally enabled or not.
After all the settings, click “Next”.
14) Now you just need to click “Install” and the actual installation of SQL Server 2022 will begin.
Here you will need to wait some time, depending on the power of your PC.
15) If everything went successfully, close the window.
16) After the SQL Server 2022 installation is complete, we need to install the application that we will use to connect to the database server. This application is SQL Server Management Studio (SSMS).
Go back to the SQL Server installation center and click “Install SQL Server Management Tools”.
17) Clicking on it will open the Microsoft website, you will need to scroll down a bit and download SSMS.
18) Open the SSMS installer and click “Install”.
19) Wait for the installation to finish.
20) Search for the application “Microsoft SQL Server Management Studio” through Windows search and open it.
21) Now you can log in with your account in SQL Server.
