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.

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-1-downloaded-exec-1.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="417" src="data:image/svg xml,” width=”617″>

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.

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-1-1-Installer-click-install.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="529" src="data:image/svg xml,” width=”611″>

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

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-1-2-load-packages.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="525" src="data:image/svg xml,” width=”611″>

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.

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-2-restart-computer.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="518" src="data:image/svg xml,” width=”597″>

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.

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-3-start-ssms.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="504" src="data:image/svg xml,” width=”620″>

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

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-3-2-ssms-loaded.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="365" src="data:image/svg xml,” width=”707″>

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.

<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-4-login-to-sql-instance.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="337" src="data:image/svg xml,” width=”697″>
<img alt="" data-ezsrc="https://kirelos.com/wp-content/uploads/2020/02/echo/ssms-4-1-logged-into-ssms.png" data-ez ezimgfmt="rs rscb4 src ng ngcb4 srcset" height="379" src="data:image/svg xml,” width=”663″>

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

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

, , , , ,
Show Comments