Installation Guideline for Microsoft SQL Server Developer + SSMS Windows 11

Microsoft SQL Server is a relational database management system. As a database server that stores and retrieves data as requested by other software applications on the same computer or a remote computer using the client-server model. Microsoft provides APIs to access SQL Server over the internet as a web service.

SSMS provides tools to configure, manage and administer instances of Microsoft SQL Server, and it brings together a range of graphical and visual design tools and rich script editors to simplify working with SQL Server.

This guide will help you install Microsoft SQL Server 2022 with SQL Server Management Studio (SSMS).


This installation guide is only applicable to Windows.


Installation Video


Downloading Microsoft SQL

Step 1: Go to the Microsoft SQL download page.

Step 2: Click on Download Now under Developers edition.

Step 3: After the download finishes, run the installer.


Installing Microsoft SQL

Step 1: Choose Basic installation.

Step 2: Click Accept.

Step 3: It is recommended to leave the install location as default. Click Install.

Step 4: Click on Install SSMS first and then close this window.


Downloading SSMS

Step 1: You will be directed to the SSMS download page.

Step 2: Click on the download link to download the latest installer for SSMS.

Step 3: After the download is done, run the installer file.


Installing SSMS

Step 1: It is recommended to install SSMS in the default location. Click Install.

Step 2: Click Close after the installation is done.

Step 3: To connect to the SQL Server, open Start Menu, type in “SQL” and click on SQL Server Management Studio.


Run Microsoft SQL + SSMS

Step 1: Click on Connect.

Result: You can check that the installation is successful when you don’t encounter any error when connecting.


 

Copyright © Asia Pacific University. All Rights Reserved.