SQL Server 2019 Developer + SSMS Installation Guide

This guide will show the process for installing SQL Server 2019 and SQL Server Management Studio (SSMS) on your workstation.

This installation guide is only applicable to Windows.

On macOS environment, you will need to run Microsoft SQL Server in a Docker container and interface with the database using compatible Database client, such as Azure Data Studio.

Installation guides:
Intel - https://database.guide/how-to-install-sql-server-on-a-mac/
Arm64 (M1, M2) - https://database.guide/how-to-install-sql-server-on-an-m1-mac-arm64/

Important: Remember to set a strong password for the Server Administrator (SA) account or the SQL Server will not run!

Preface

To setup SQL Server in your workstation, you need to have at least the core function installed. The SQL Server installer will install the back-end service(s) that handle the database, while SQL Server Management Studio (SSMS) is responsible for providing the interface to access and interact with the database. Everything you do will go through a database manager before the changes are reflected in the database.

Login to Microsoft Azure Dev Tools for Teaching

Go to APU Webspace or click here to access Azure Dev Tools login page.

Enter your student Office 365 account email, click Next. (Email format: TPXXXXXX@mail.apu.edu.my)

Enter your APkey password. Click Sign In.

Click Yes if you want to keep login session. Click No if you don’t want to stay signed in.

Download SQL Server 2019 Developer and SSMS

Click on Download software or Learning resources > Software to view the list of softwares available for download.

Enter the keyword “SQL server” in the search box. Select SQL Server 2019 Developer and click Download to download the installation media.

Next, navigate to SQL Server Management Studio download page on your browser to download the latest version of SSMS installer.

Once you downloaded both installation media, double click on the ISO file to mount the installation media using Windows Explorer.

Double click on setup.exe to start the installation process.

Install SQL Server 2019 Developer

You will see SQL Server Installation Center. Click on Installation.

Click on New SQL Server stand-alone installation or add features to an existing installation.

We will be using Developer version. Click Next.

Select “I accept the license terms and Privacy Statement” and click Next.

The setup will check for several rules on your computer. Click Next.

Normally a warning will appear for Firewall, as firewall by default will block unused ports that SQL Server might require to perform tasks like remote access.

We will not address the issue as it will not interfere with the functionality required for the course.

Select “Database Engine Services”. Click Next.

You can change your SQL Server instance name and ID here. Click Next.

You can change how the SQL server services act during the system startup. Click Next.

You need to configure the server authentication and add a SQL Server administrator (normally your user account). Click on Add Current User, wait, and click Next.

Click Install.

Depending on your computer specification, it will take around 10 minutes to install SQL Server.

Once you installed everything successfully, click Close.

Install SSMS

Double click on the SSMS installer (SSMS-Setup-ENU.exe). Click Install.

Depending on your computer specification, it will take around 10 minutes to install SSMS.

Click Close.

After Installation

After installing SQL Server and SSMS, you can use the database.

Open “Start” and type in “ssms”. Click on “Microsoft SQL Server Management Studio 18”.

You should see this window for you to connect to the server. Click Connect.

If you manage to connect to the server successfully, you will see this in Object Explorer.