Introduction

From 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 SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.

You have the liberty to use SSMS to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud. Best of all, Microsoft has given us this tool for free. You will find a download link in this Microsoft Site. We should get to work now.

Step 1: Install the application

Navigate to the folder where your executable file has been downloaded and double click it to start the installation process.

ssms 1 downloaded exec 1

Once the installer fires up, you can either choose a different installation location or just leave the default location. Click “Install” to begin your installation.

ssms 1 1 Installer click install

The installer will begin loading packages and that might take a brief while.

ssms 1 2 load packages

Step 2: Restart your computer

After the installation is complete, you will see a message as shown below asking you to restart for the setup to complete. I know it is boring but we have no choice. Just click on the “Restart” button to restart your Windows 10 computer so that we complete the installation process.

ssms 2 restart computer

Step 3: Load up SQL Server Management Studio

After you have restarted your computer, hit the “Windows” button and search for “SQL Server Management Studio” and click on it to start the application.

ssms 3 start ssms

Your SQL Server Management Studio should show up after that as shown below.

ssms 3 2 ssms loaded

Step 4: Ensure your database instance is well configured

Make sure the database instance has been configured to listen on a certain port and the port has been allowed in the Windows firewall if it is running.

Kindly use the guides below to do that if it has not been done.

How To Configure MS SQL Server to Listen on a given port

How To open a port in Windows Server Firewall

Step 5: Connect to your Database Instance

In-case your server has a resolvable name (one that your internal DNS can resolve to an IP address), input it in the server name area. Otherwise, just key-in the IP address of the SQL server. Change “Authentication” to “SQL Server Authentication” unless you have joined the server to a domain controller. Type in Login username such as “sa“(default admin) and type in its password. We should be able to log in and presented with the contents as shown in the images below.

ssms 4 login to sql instance
ssms 4 1 logged into ssms

Now you have the freedom to create and use databases. Simply right-click on databases and choose “New Database”. Have an amazing

Conclusion

Thank you for visiting and following along with the guide. We hope it all went well on your side. Before you leave, you might be interested in the following related articles and guides.

Install SQL Server 2019 Developer Edition on Windows Server 2019

Install and Configure OpenSSH Server on Windows Server 2019

Install and Configure IIS Web Server on Windows Server 2019

Install and Configure NFS Server on Windows Server 2019

Install Latest Packer on Linux / FreeBSD / macOS / Windows

Install Terraform on Windows 10 / Windows Server 2019

Your support is our everlasting motivation,
that cup of coffee is what keeps us going!


As we continue to grow, we would wish to reach and impact more people who visit and take advantage of the guides we have on our blog. This is a big task for us and we are so far extremely grateful for the kind people who have shown amazing support for our work over the time we have been online.

Thank You for your support as we work to give you the best of guides and articles. Click below to buy us a coffee.

LEAVE A REPLY

Please enter your comment!
Please enter your name here