SQL Server Setup and Installation (A-Z)

 

Requirements: Minimum 2 Core machine with 4 GB RAM

Download: SQL Server 2019, SQL Server Management Studio, SQL Server Reporting Service

Download SQL Server 2019 Developer Edition

 

Step -1

Download SQL Server from this link.

Run the downloaded file and select one of the installation types from Basic, Custom or Download Media

Step -2

Download the required ISO file by selecting download

Step -3

After downloading successful press close and extract the file

 

Step -4

Once extraction is completed, double click on the setup.exe file and you will see the below screen. Click on the Installation option in the left panel and then click on New SQL Server stand-alone installation or add features to an existing installation option from the right panel.

 

 

 

Step -5

Product Key window will be shown up. Select the Developer option from the dropdown and click on the Next button.

 

 

Step -6

Check the I accept the License Terms and Privacy Statement from License Terms window and click on next button.

 

 

Step -7

Check the use Microsoft Update to check for updates from Microsoft Update window. You can keep uncheck it because it is optional. Click the Next button.

 

Step -8

Now it will check for updates and install them if any. Install Setup Files window will show up.

 

Step -9

After Install Rules click next button.

 

Step -10

On the Feature Selection window, select features as shown in the below picture. You can also change the location for SQL Server instance installation, but I will recommend for go with the default location. After feature selection please click the Next button.

Step -11

It will check some feature rules/prerequisites and then you will see the Instance Configuration screen. Here you can choose between Default Instance and Named Instance. Here I will recommend for go with Default Instance.

 

Step -12

Next, you will see the Server Configuration window. In Service Accounts tab, select Automatic in Startup Type for SQL Server Agent, SQL Server Database Engine, and SQL Server Browser services. Click next button.

Step -13

        

Next, you will see the Database Engine Configuration window. In the Server Configuration tab, choose Mixed Mode in the authentication mode section and enter a strong password. In Specify SQL Server administrators’ section, your current windows user should already be added automatically. If not, click on Add Current User button. Click next button.

Step -14

Next, the setup will check some feature configuration rules, and then the Ready to Install window will appear. This window shows the summary of all the features and configurations which we have done in the above steps. Once review the summary and click on the Install button.

 

 

Step -15

After installation, it will show you the list of features and their installation status. If any error occurred, it will show here. Click close button.

 

 

 

Install SQL Server Management Studio

First, download SQL Server installation media from the official website.

Step 1

Download installation media from these link.

Step 2

Below file will be downloaded.

Step 3

Run the downloaded file and you will see below screen. Just click on the Install button.

 

Step 4

It will start installing SQL Server management Studio. It will take some time.

Step 5

Once installation Completed, close the installation wizard and open start menu and search for SQL Server Management Studio. You will see below application. Now, click on it to open the application.

Step 6

Next, you will see below screen. In Connect to Server window, you can see the SQL instance name, which we have just installed. (Ref. Step 9). You can connect an instance with SQL Authentication, which we have created in Step 13.

Step 7

Once you successfully authenticated, you can see Object Explorer in which you can find database list and other SQL objects.

Here, you go with SQL Server. Thank you