How to Install SQL Server Management Studio?

SQL Server Management Studio is a software application launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administrating all components within the Microsoft SQL Server. It is one of the SQL Server management tools, regardless of your location used for designing queries and managing databases and data warehouses via personal computer or cloud.

Note: Azure Data studio is automatically installed alongside SQL Server Management Studio. SSMS in the latest version 18.8 point Azure Data Studio is a crowd cross-platform and open source desktop pool for your environment, whether in the cloud, on-premises, or hybrid.

Installing SQL Server Management Studio

Step 1: To install SQL Server Management Studio you need to start the search engine search for downloading the SSMS (SQL Server Management Studio) and click on the official website.

Step 2: After the link is opened click on the Download SSMS link. 

Step 3: Your download will be started as soon as possible, if not started refresh or wait for a few seconds and after the completion opens the .exe file of the setup.

Step 4: Setup SQL Server Management Studio. Open the location in which you downloaded the setup’s .exe file and right-click on the setup file and click the option run as administrator after then the below panel will be opened and for further installation process click the install button.

Step 5: After Loading packages progress bar will be shown. When is packaged progress and overall progress. Wait for a few minutes while the installer sets up the software. If any problem occurs during the installation restart the system and try again from step 4.

Step 6: Go to all programs. In our systems, we concede to folders in the MySQL server list. Another word is Microsoft SQL Server 2018 under Microsoft SQL Server tools 18. Microsoft SQL Server Management Studio 18.

Step 7: After opening SQL Server Management Studio 2018 we can see that it looks like the below screenshot.

Now we can connect to the server and use SQL Server Management Studio 2018.

Step 8: Now select the database engine and choose your system name and then click the connect option.

Step 9: Now all the databases present on your system will be shown on the left pane as shown below.