In a previous post, I shared a video on how to install SQL Server 2014. Since SQL Server 2014’s mainstream support ended on July 9, 2019. I have added a step by step instruction on how to install the 2017 version.

  1. You can download SQL Server 2017 here.
  2. It should automatically download the “SQLServer2017-SSEI-Dev.exe” file.
  3. After the download completes, check your “Downloads” folder to locate the downloaded file.
  4. Double click on the “downloaded” file and click “Yes” on the prompt.
  5. Click “Basic” when the dialog below appears.

6. Click “Accept”

7. Click “Install”

Installation Progress

8. Once download is complete, write down the Value under the “Instance Name” You will need it later.

In my case the instance name is MSSQLSERVER01


Launching SSMS – 2017 Version

  1. After installation is complete, Search for “SSMS” in the windows search box

2. click the “Microsoft SQL Server Management Studio 18” option

3. Click “Connect”

Final screen

Now that you have SQL Server and SQL Server Management Studio installed, you can then install some databases to write queries against. You can read my post Sample SQL Server Databases on where to download some database samples. You can also check my post on how to install the AdventureWorks database.