Download and install Microsoft Management Studio
Downloading and installing Microsoft Management Studio is explained in the following steps.
Table of contents
- Download the software package
- Installing the software package
- Logging in to SQL Server via Microsoft Management Studio
|
1. Downloading the software package
Download the Microsoft Management Studio installation software package from the address below: https://aka.ms/ssmsfullsetup
2. Installing the software package
After downloading, the user runs the installation package SSMS-Setup-ENU.exe with full administrator rights.
Right-click and Run as administrator/Run as administrator.
Confirm User account control by pressing the Yes button.
Confirm the installation by clicking Install.
The software will start installing on our workstation.
The speed of installation depends on the power of the hardware on our workstation.
Once the program has finished installing, the user confirms that the installation is complete by clicking on the Close button.
 |
WARNING
After installing Microsoft Management Studio, we recommend restarting your computer.
|
3. Login to SQL Server via Microsoft Management Studio
The user searches for Microsoft SQL Server Management Studio 18 in the Start menu and starts it.
Wait for Managament Studio to start. The speed of the program opening depends on the power of the workstation hardware.
|
WARNING
To start Microsoft SQL Server Management Studio faster, you can uncheck Advanced/Advanced on the Internet options, tab within Internet settings/Internet options,:
- Check for publisher's certificate revocation
- Checl for server certificate revocation
- Check for singatures on downloaded programs
|
The user fills in the login details he/she specified when installing Microsoft SQL Server 2019 Express.
Example of login details:
| Server type: |
Database Engine |
| Server name: |
.\DATALAB |
| Authentication: |
SQL Server Authentication (login with sa user)
Windows Authentication (Windows user login)
|
| Login: |
with |
| Password: |
The password we set for sa user when installing Microsoft SQL Server 2019 Express. |
| Remember password |
Toggle if we want Management Studio to remember our login to the SQL Server in question. |