Back to: ASP.NET Core Tutorials For Beginners and Professionals
How to Download and Install SQL Server 2022
In this article, I am going to discuss How to Download and Install SQL Server 2022 on Windows Operating System. Please read our previous article, where we discussed How to Download and Install Visual Studio Code.
Next, we are going to install SQL Server 2022. Remember, we are going to develop Data-Driven Web Applications; we need some data. We can hard code the data in memory. But in Real-time, we need to work with databases. As a database, in this course, we are going to use SQL Server. Now, let us download and Install SQL Server 2022 Developer Edition.
How to Download SQL Server 2022
So, let’s download it, and then we will talk about the installation. So go to Google.com or your favorite search engine and have a look for Download SQL Server 2022. And you can see that the top instance here is from Microsoft.com. So, click on it as shown in the below image.
You can also directly visit the following URL to download SQL Server Latest Version:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Once you click on the above link, you will see three big entries at the top, as shown in the image below.
We don’t want any of those. Instead, go down and download a free specialized edition. And in this case, we’re going to download the developer edition. So, click the Download Now button, as shown in the image below.
Once you click on the Download Now button, it downloads a very small document (actually the SQL Server Developer Edition 2022 EXE file) which is only about five megabytes, as shown in the below image.
Now click on the above EXE file or double-click on the exe file from its downloaded folder, and one popup will open. Simply click yes, and then it will ask you what you want to download, as shown in the below image. Do you want to download a very basic version with the default configuration? It will allow you to make the select statement. It will allow you to do some database administration but not much more. So, if you want to do other things, such as SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), and SSRS (SQL Server Reporting Services), then don’t select the Basic option. The other options are Custom and Download Media. I like to Download Media simply because I want to be able to reuse it on multiple computers. So, I click on the Download Media option, as shown in the below image.
The following window will open once you click on the Download Media option. Here, I am going to download it as a CAB. This is a compressed media that contains .exe and .box files. Next, select the language as English and select the download location, and here, I go with the default location and finally click on the Download button as shown in the below image.
It will take some time to download the required files, and once the download is successful, you will get the following message. Once the download is successful, I will open the folder next. To open the folder, click the Open Folder button, as shown in the image below.
And the following image shows the folder content. It just contains two files, i.e., one .exe and one .box file.
Installing SQL Server 2022 on Windows Operating System:
In order to install SQL Server, double-click on the EXE file, as shown in the image below.
Once you double-click on the exe file, one popup will appear asking, “Do you want to allow this app to make changes to your device?” simply click on Yes, as we are going to make changes. Once you click yes, it will ask you to select the location for the extracted files, as shown in the image below. In my case, I am going with the default location, C:\Users\Pranaya\Downloads\SQLServer2022-DEV-x64-ENU\, and clicking on the OK button, as shown in the image below.
It will extract all the files into the specified folder, as shown in the below image.
Once the extraction is completed, it will open the following SQL Server Installation Center. There are a lot of tabs on the left-hand side, and we don’t need to know much about them at the moment. We are only interested in the Installation tab, so click on the Installation tab as shown in the below image.
Once you click on the Installation tab, the following window will open. Here we need to click on the New SQL Server Standalone Installation and Add Features to an Existing Installation option, as shown in the below image.
Once you click on the above link, it will open the automatically install some setup files and then click Next if you get the following screen. If you are getting Windows Firewall Warning. This is fine, and you can proceed by clicking on the Next button, as shown in the below image.
Once you click on the Next button, it will open the Installation Type window. Here, you can choose whether you want a new SQL Server Installation or you want to add features to an existing SQL Server installation. I want a new SQL Server Installation, so I choose the Perform a new installation of SQL Server 2022 radio button and click on the Next button as shown in the below image.
Once you click on the Next button, it will open the following Product Key window. Now, in this window, it is asking what Edition you want. Do you want the Developer Edition, or do you want the Express Edition? Or are you downloading one of the standard or enterprise editions and you want to give it 180 days trial, or have you got a product? Well, I’m going to download the developer edition. I’m going to install the developer edition. So, I select the Developer Edition and click the Next button, as shown in the image below.
Once you click on the Next button, it will open the following License Term window. Here, you need to accept the License Term by checking the checkbox and clicking the Next button, as shown in the image below.
Once you click on the Next button, it will open Azure Extension for SQL Server. Currently, we don’t have an Azure account, so we need to uncheck the Azure Extension for SQL Server checkbox and click on the Next button, as shown in the image below.
Once you click on the Next button, it will open the Feature Selection window. Here, you need to select what you want to install. If you want to build your select statements and database administrator, you need to select the Database Engine Services checkbox. If you are looking for SSAS, select the Analysis Services checkbox. If you’re looking for SQL Server Integration Services, then you need to select the Integration Services checkbox. If you’re looking for anything else, then you can select that checkbox from the list. And if you want to select everything, you can click the Select All button.
For the purpose of this course, I am just going to install the Database Engine Services only, not the analysis services or integration services. If you want, you can install them. If you do not have enough space in the C drive, you can change the instant root directory to any other drive. But I have enough space on the C drive, so I am going to create the instant root directory on the C drive. So, from this window, select the Database Engine Services checkbox and click on the Next button, as shown in the below image.
Once you click on the Next button, it will open the following Instance Configuration window. If you are installing SQL Server for the first time, then you need to select the Default Instance radio button. But I have already installed a different instance of SQL Server. So, I cannot select the Default Instance radio button as I have already selected the same with a different SQL Server Installation. So, I am selecting the other radio button, i.e., Named Instance, giving the name SQLServer2022Dev, and clicking on the Next button, as shown in the image below. Notice that whatever name we provided, either in Default Instance or Named Instance, will become the Instance ID of this SQL Server installation.
Once you click on the Next button, it will open the following Server Configuration window. I suggest you don’t make any changes in this window and simply click the Next button, as shown in the image below.
Once you click on the Next button, it will open the Database Engine Configuration window. We are going to be installing Mixed Authentication Mode. This means that we can log in to the database using Windows Credentials as well as SQL Server Credentials. Here, I am providing the password as SQLServer@2022. And I want to add the current user as an administrator. For this, click on the Add Current User button. Administrators have all of the power that you need in the instance. Then click on the Next button, as shown in the below image.
Once you click on the Next button, the Ready to Install window will open, which means the SQL Server instance is ready to install. So, click the Next button, as shown in the image below, to start installing.
Once you click on the Install button, it will start installing. Once the installation is completed, you will get the following message. Click on the Close button to close the installation.
Whatever we installed now is the backend. Next, we need to install the front end. That is the interface or client tool using which we can connect to the database and perform database operations.
In the next article, I am going to discuss How to Download and Install SSMS on Windows Operating System. In this article, I explain How to Download and Install SQL Server 2022 on Windows Operating System. I hope you enjoy this Download and Install SQL Server 2022 article.
