Back to: SQL Server DBA Tutorials
How to Download and Install SQL Server
In this article, I am going to show you How to download and Installed SQL Server 2019 Developer Edition. So, let’s just download it, and then we will talk about it. So go to Google.com, or your favorite search engine and have a look for download SQL Server 2019. And you can see that the top instance here is from Microsoft.com. So, click on it as shown in the below image.
Once you click on the above link, then you will see three big entries at the top as shown in the below image.
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 on the Download now button as shown in the below image.
Once you click on the Download now button, it downloads what’s called a bootstrap, a very small document, only about five megabytes as shown in the below image.
Now click on the EXE file, 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 do the select statement. It will allow you to do some database administration, but not much more. So, if you wanted 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.
Once you click on the Download Media option, the following window will open. 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 am going with the default location and finally click on the Download button as shown in the below image.
So, it’s going to take quite a while to download. Meanwhile, I’m just going to talk about some other things. So, let’s have a look at the following five different things.
- SQL Server on Azure: Microsoft Azure is Microsoft in the cloud. So you can get SQL Server on the cloud as the back engine. What we are downloading at the moment is the back engine, not the thing that you can see, but the thing that runs in the background and then you can query that from your computer. The problem is there is a cost to that. It’s not necessarily a huge cost, but there is a cost.
- SQL Server at the Edge: You can extend it to the Internet of Things devices as well.
- SQL Server on-premises: Now, if you’re using this for work purposes, then you’re probably looking at the Enterprise Edition or the Standard Edition. The Enterprise edition is the really big version, but also of a big price tag, Standard Edition with a hugely cut down cost.
Now, there are two free specialized editions.
- Express Edition: The Express Edition is fine if you just want to do select statements and if you want to do some database administration. But there is also the Developer Edition.
- Developer Edition: It is a full-featured free edition. It features all of the functionality of the Enterprise edition.
So, why do people go for the Enterprise edition, not the free developer edition?
Because it is only licensed for use as a development and test system, not in production. So, if you are going to learn SQL Server, it’s ideal for that development and test system and it allows you access to all of the various strands of SQL server as Reporting services, Integration services, Analysis services, as well as the Select statements and database administration.
You will see that the Express Edition is the best choice for developers and hobbyists building client applications. It is a very quick install, but you can’t expand it if you want to go into SSRS, SSAS, and SSIS.
Hardware Requirements to Install SQL Server:
The following Hardware requirements need for SQL Server installations:
- Hard Disk: SQL Server requires a minimum of 6 GB of available hard-disk space.
- Monitor: SQL Server requires Super-VGA (800×600) or a higher resolution monitor.
- Internet: Internet functionality requires Internet access (fees may apply).
- Express Editions: 512 MB
- All other Editions: 1 GB
- Express Editions: 1 GB
- All other Editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
- Minimum: x64 Processor: 1.4 GHz
- Recommended: 2.0 GHz or faster
Processor Type: x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
Note: Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.
Software Requirements to Install SQL Server:
The following requirements apply to all Editions of SQL Server installations:
- Operating system: Windows 10 TH1 1507 or greater. Windows Server 2016 or greater
- .NET Framework: Minimum operating systems include a minimum .NET framework.
- Network Software: Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, and TCP/IP.
For more information, please click here.
Right, we can see that our download was successful, on successful download, we will get the following message. Once the download was successful, next I am going to open the folder. To open the folder, click on the Open Folder button as shown in the below image.
And the following image shows the folder content. It just contains two files and .exe and .box file.
Now, we will see how to install SQL Server 2019.
Installing SQL Server 2019:
In order to install SQL Server, simply double-click on the EXE file as shown in the below image.
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 choose yes, then it will ask you to select the location for the extracted files as shown in the below image. I am going with the default location which is in my case C:\Users\HP\Downloads\SQLServer2019-DEV-x64-ENU\ and click on the OK button as shown in the below image.
It will extract all the files into the SQLServer2019-DEV-x64-ENU 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 Microsoft Update window. From this window checked the use Microsoft update to check for updates checkbox and click the Next button as shown in the below image. If you don’t want this feature, then unchecked the check box.
Once you click on the Next button, 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 2019 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 do 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 on the Next button as shown in the below image.
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 then click on the Next button as shown in the below image.
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 are looking to build your select statements and database administrator, then you need to select the Database Engine Services checkbox. If you are looking for SSAS then you need to 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, then you can click on 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. One more thing, if you do have not enough space in the C drive, then you can change the instant root directory to any other drive also. 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 as SQLServerDev, and clicking on the Next button as shown in the below image. 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 on the Next button as shown in the below image.
Once you click on the Next button, it will open the Database Engine Configuration window. We are going to be installing Windows Authentication Mode. This means that anyone who tries to connect to this SQL Server instance will be using their windows login. 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, it will open the following Ready to Install window. That SQL Server instance is ready to install. So, click on the Next button as shown in the below image to start installing.
Once you click on the Install button, it will start installing as shown in the below image.
Once the installation is completed, you will get the following message. Click on the Close button to close the installation.
Next, we need to install the front end. Whatever we installed now is the backend. So, in the next article, I am going to show you how to download and install the front end which is in our case SSMS (SQL Server Management Studio). Here, in this article, I try to explain How to download and Installed SQL Server 2019 Developer Edition and I hope you enjoy this download and Installed SQL Server 2019 Developer Edition article.