In this tutorial, I will explain how to install SQL Server Management Studio. As a beginner, you must have knowledge about what are the procedures to install SQL Server Management Studio.
After completing this tutorial, you will be ready to install the SQL Server Management Studio on any platform.
SQL Server Management Studio
Before getting into installation, we will see what SSMS is.
SSMS stands for SQL Server Management Studio, a graphical user interface (GUI) tool for configuring, monitoring, and administering SQL Server databases. This software can also create tables, views, stored procedures, and functions. Use this link to download SSMS: https://aka.ms/ssmsfullsetup.
- Once downloading is over, run the SSMS-Setup.exe file. Now, a welcome message will appear. Note that this wizard installs not only SSMS but also Azure Data Studio (to be discussed later in this tip).
- Check the location and make changes if a different location you want. Click Install to continue.
- Once the installation is done, a Setup Completed message will appear. You now have SSMS installed.
- Once installed, you can search in the search bar. Click on SQL Server Management Studio 20.
- Now, enter the username and password and click Connect. If you can’t open it, click Authentication, choose Windows, and click Connect. It will automatically connect to your server management studio.
- Once it is connected, you can start working.
Below are the terms to know under the SQL Server instances.
| Folder | Description |
| Databases | It has all the databases available on your SQL Server, such as the system and user databases. Here, you can perform all database-related operations, such as database creation, deletion, etc. |
| Security | It contains the various SQL Server Security subfolders, including database roles, logins, and server roles. You can control user permissions, accounts, and security settings for your SQL Server instance by using this node. It also lets you assign roles, make new logins, and more. |
| Server Objects | This node has a collection of settings, objects, and other items at the server level, such as servers, triggers, endpoints, etc. |
| Replication | Data can be transferred between databases via replication. You can control and set up database replication with this node. |
| Management | This node helps you control SQL Server performance and settings. It offers items like Data Collection, Policy Management, and Maintenance Plans. It also allows you to maintain and check the SQL Server environment. |
| XEvent Profiler | It is a node that gives you access to Extended Event sessions, which you can use to record and examine event data and SQL Server performance. |
Conclusion
I hope you have clarity on how to install SQL Server Management Studio [SSMS]. Also learned how to create a SQL Server instance.
You may also like to read:
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
