Back to: ASP.NET Core Tutorials For Beginners and Professionals
How to Download and Install SSMS
In this article, I am going to discuss How to Download and Install SSMS on Windows Operating System. Please read our previous article, where we discussed How to Download and Install SQL Server 2022 on Windows Operating System. Once you have installed the SQL Server database, then you need an interface to interact with the SQL Server Database. And for that, we are going to use SQL Server Management Studio (SSMS) to interact with the SQL Server database.
What is SQL Server Management Studio (SSMS)?
According to Microsoft, SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of the SQL Server databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts. Use SSMS to query, design, and manage your databases and data warehouses, wherever they are – on your local computer or in the cloud.
How to Download SQL Server Management Studio (SSMS)?
Open any web browser and type SSMS SQL Server 2022, and then you will see that the first link will be Download SQL Server Management Studio from Microsoft. So, click on the link as shown in the below image.
Alternatively, you can download and install the SQL Server Management Studio from the below link.
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Once you click on the link, it will open the following Download SSMS page. Here, you can see we’ve got the latest version. Now, the latest version keeps updating every two months or so. So, it may be a completely different version from the one that you’ve seen here. However, it doesn’t matter. They’re all basically the same at the intermediate level in terms of styling and other things. So, click the Free Download for SQL Server Management Studio (SSMS) 19.1 button, as shown in the image below.
It will start downloading the EXE file, which is between 600 to 700 MB, as shown in the image below.
Here, there will be two programs that will be installed, SSMS and Azure Data Studio. Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.
How to Install SSMS (SQL Server Management Studio)?
Once the download is completed, click on the EXE file to open the following Install window. Here, if you want to change the directory, you can change it, and then you need to click on the Install button, as shown in the below image.
Once you click on the Install button, it will ask, “Do you want to allow this app to make changes to your device”? Click yes. Once you click Yes, it will start downloading the SQL Server Management Studio, and you can also check the download progress as shown in the below image.
It will take some time to install SSMS. Once the installation is completed, you will get the following message.
To use SSMS to connect with SQL Server Database, type SSMS in the search bar and click on the Microsoft SQL Server Management Studio 18 option, as shown in the image below.
Once you click on the SSMS app, it will open the following Connect to Server window.
Now, you need to identify to which SQL Server Instance you need to connect. So, if you’re connecting to your default instance, you will probably use localhost or just a dot. Otherwise, you could click on Browse for more connections and then find a connection, or you might be given a server name. So, let us click on Browse for more connections, as shown in the below image.
Once you click the Browse for more connections, it will open the Browse for Servers popup. Here, you need to select the Database Engine and then select the SQL Server Instance to which you want to connect. In my case, I want to connect to SQLServer2022Dev and then click on the OK button, as shown in the below image.
Once you click on the OK button, it will return to the Connect to Server window, and if you notice, the Server Name is populated. Next, select the Authentication mode as Windows Authentication and click on the Connect button, as shown in the image below.
Once you click on the Connect button, it will connect to SQL Server Database, and you will get the following SQL Server Management window where you can do all types of Operations.
In the next article, I am going to discuss How to Download and Install Postman and Fiddler. In this article, I explain How to Download and Install SSMS on Windows Operating System. I hope you enjoy this Download and Install SSMS article.
