How to Download and Install SQL Server?

Last updated on 12th Oct 2020, Blog, Tutorials

About author

Vikram ( (Sr Project Manager ) )

He is Highly Experienced in Respective Technical Domain with 6+ Years, Also He is a Respective Technical Trainer for Past 5 Years & Share's This Important Articles For us.

(5.0) | 16547 Ratings 2350

How to download SQL Server Setup

Step 1)

Go to URL: https://www.microsoft.com/en-in/sql-server/sql-server-downloads

Microsoft provides two specialized free editions to work on MS SQL server:

    1. 1.Developer – It has all features which MS SQL server offers but we cannot use it in production. From the learning perspective, is it an ideal candidate to start.
    2. 2.Express: This is also a free version but with the limited set of features with no business intelligence applications.

We will select the Developer edition for installation.

Subscribe For Free Demo

Error: Contact form not found.

Step 2)

Click on “Download now”

specialised-editior

We will get set up as ‘SQLServer2017-SSEI-Dev.exe’.

SQL-server

How to Install SQL Server

Step 1)

Double click on “SQLServer2017-SSEI-Dev.exe”. Below screen will appear with three options: Basic, Custom and Download files.

Custom-and-Download

Step 2)

Choose the basic version by clicking on the ‘Basic’ option, as it has all default configuration required to learn MS SQL.

Basic-option

Step 3)

‘Microsoft Server License Terms’ screen will appear. Read the License Terms and then click ‘Accept.’

Microsoft-Server-License-Terms

Step 4)

Below the ‘SQL server install location’ window will appear.

    1. 1.The Default location is C:\Program Files\Microsoft SQL Server.
    2. 2.Optionally, we can also change the installation location by clicking on Browse.
    3. 3.Once the location is selected, click the ‘Install’ button.
default-location

Below the ‘Downloading install package’ progress screen will be displayed. Wait until the download is complete.

install-package

Once the download is complete; the system will initiate installing a developer edition.

installation-progress

Below screen shows installation progress.

developer-editor

Step 5)

Once installation is completed successfully, the below screen will appear.

Close-this-window

This setup is self-sufficient for proceeding further with learning SQL server, and we can ‘Close’ this window.

Course Curriculum

Enhance Your Career with SQL Server Training from Real Time Experts

  • Instructor-led Sessions
  • Real-life Case Studies
  • Assignments
Explore Curriculum

However, below is a summary of the label and button:

    1. 1.Instance name: This is by default labeled as MSSQLSERVER.
    2. 2.Connect now: This will open a separate command line window for connection testing of what we have just installed.
      The system will run by default ‘select @@Version’ statement to confirm that we can connect to the new MSSQLSERVER instance successfully.
SQL Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download
customize-further
    1. 1.Customize: This will open the SQL Installation center to customize further and add features other than which are there as a part of the BASIC installation.
    2. 2.Install SSMS: This is IDE which will take us to Microsoft SSMS download link. We will cover SSMS in detail in our SSMS tutorial.
    3. 3.Close: This will close this window. The user is now ready to install SSMS IDE as instructed in SSMS tutorial.

Are you looking training with Right Jobs?

Contact Us

Popular Courses