Important: Remember to set a strong password for the Server Administrator (SA) account or the SQL Server will not run!
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.
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 may select other services if you require it. Do note that installing every services and features will takes up 14GB of hard disk space.
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.
You may use Mixed Mode, where a built-in sa (SQL Server system administrator) account will be enabled. You will need to provide the sa account password if you choose this authentication mode.
Once the authentication mode is setup, you can use sa account to connect to the SQL server, as well as using Windows account who were assigned as SQL Server administrators.
Depending on your computer specification, it will take around 10 minutes to install SQL Server.
Once you installed everything successfully, click Close.
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.
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.
If you used Mixed Mode for authentication, you may login using SQL Server Authentication mode and enter your sa account credentials.
If you have more than one server Instances installed, you can change it in Server name by clicking <Browse for more…>.If you have more than once Instances, you will see multiple items under Database Engine.
By default, SQL Server service will run upon system startup, unless you changed the settings during instance setup.
If you are not sure, you can check through services.msc by using Run… prompt (Shortcut: ⊞ WIN + R).
Ensure SQL Server service is Running. If you set it to Manual, you will need to start the service manually.