How to Install Microsoft SQL Server Express and SQL Server Management Studio !

Hello I am Amey Bhilegaoknar, grader at ASU for IFT 300: Intermediate Database Management Systems.

In this blog, I am writing instructions and steps to be followed to install Microsoft SQL Server Express and SQL Server Management Studio.

Photo by Caspar Camille Rubin on Unsplash

Installing Microsoft SQL Server Express

Go to this link to download MS SQL Server Express : Download MS SQL.

Check if your laptop or pc meet the system requirements.

Download .Net SP 3.5 SP 1 from here: Link

or Download Microsoft .Net Framework 4.0

Note: SQL Server Express (with database engine only) can work with either .NET 3.5 SP1 or .NET 4, there is no need to have both enabled.

Step 1 : Downloading .Net Version

After successful installation of one of the frameworks from above steps install the required version of MS Server from Download button from this link.

Step 2 : Downloading your preferred version of SQL Express

After downloading the required file, follow the following installation screenshots for the steps:

Step 3: Accept the terms and choose Next

Step 4: choose Install

Step 5: Select All and Choose Next

Step 6: Choose Next

Step 7: Choose Next

Step 8: Choose Next

Step 9: Choose Next

Step 10: Check if everything is Installed properly

If everything is installed properly move on to the next step.

Installing SQL Server Management Studio (SSMS)

Go to this link to follow download instructions.

or Click here to download SSMS 18.12.1

Once downloaded follow the instructions to install:

Step 1: Click Install

Restart Computer

Post Restart run the app from the startup menu and connect to the DB

Select Connect

If the connection is successful, congratulations, you are all ready to for IFT 300 class at ASU.

If you find this blog useful, please like it and share it with your classmates and checkout my socials below.

Amey Bhilegaonkar | PortFolio

LinkedIn: Amey Bhilegaonkar

Instagram: @ameygoes

GitHub: ameygoes