---
title: How to connect to MSSQL database using Microsoft SQL Server Management Studio (SSMS)
description: "To connect remotely to a MSSQL Database, is a seamless process that can be achieved using the steps below. ### Using : **Microsoft SQL Server Management Studio** In this guide we shall be using Microsoft SQL Server Management Studio. ###…"
url: "https://truehost.com/support/knowledge-base/how-to-connect-remotely-to-mssql-database-using-microsoft-sql-server-management-studio/"
updated: "2024-10-08"
category: Plesk
---

# How to connect to MSSQL database using Microsoft SQL Server Management Studio (SSMS)

To connect remotely to a MSSQL Database, is a seamless process that can be achieved using the steps below.

### Using : **Microsoft SQL Server Management Studio**

In this guide we shall be using Microsoft SQL Server Management Studio.

### **`Download SSMS HERE`**

#### **Step 1:**

First Ensure you have created a database on Plesk.

Login to Plesk ->Databases -> Add Database -> Fill your details and click ok.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-161.png)

Once completed, Click on Connection Info to preview your details as below

For my case I have created a database name "dannydev_test1", username as "dannydev_test1"

and my "password" and Host as .\MSSQLSERVER2019

![](https://truehost.com/support/wp-content/uploads/2024/10/image-162.png)

#### **Step 2:**

Open Microsoft SQL Server Management Studio.

You will see a window as show below.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-163.png)

##### Fill your details.

Note that some details will vary depending on your database Host.
See link below for the correct details depending on this.

> [How to Connect Remotely to MSSQL Database](https://www.truehost.com/support/knowledge-base/how-to-connect-remotely-to-mssql-database/)

[“How to Connect Remotely to MSSQL Database” — ](https://www.truehost.com/support/knowledge-base/how-to-connect-remotely-to-mssql-database/embed/#?secret=IPGykaiowH#?secret=TBqkLVUrr9)

Click Connect and you will see a window as shown below upon successful connection.

You can click on Databases to expand (can take sometime) scroll down and you will see your database listed

In my case (dannydev_test1) as below.

![](https://truehost.com/support/wp-content/uploads/2024/10/image-164.png)

That's It. All done.