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:

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”


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


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.


Step 2)

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


Step 3)

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


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.

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


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


Below screen shows installation progress.


Step 5)

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


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
    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