...
This guide will show the process for installing SQL Server 2019 and SQL Server Management Studio (SSMS) on your workstation.
| Info |
|---|
SQL Server 2019 Developer and SSMS are only available in This installation guide is only applicable to Windows.However, there are ways to install SQL Server using Docker and interact with it using third-party software like DBeaver. |
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.
...
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.
...
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.
...
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.
...