{"id":14664,"date":"2024-10-08T09:02:48","date_gmt":"2024-10-08T09:02:48","guid":{"rendered":"https:\/\/truehost.com\/support\/?post_type=docs&p=14664"},"modified":"2024-10-08T09:45:31","modified_gmt":"2024-10-08T09:45:31","password":"","slug":"how-to-connect-remotely-to-mssql-database-using-microsoft-sql-server-management-studio","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-connect-remotely-to-mssql-database-using-microsoft-sql-server-management-studio\/","title":{"rendered":"How to connect to MSSQL database using Microsoft SQL Server Management Studio (SSMS)"},"content":{"rendered":"\n

<\/p>\n\n\n\n

To connect remotely to a MSSQL Database, is a seamless process that can be achieved using the steps below.<\/p>\n\n\n\n

Using : Microsoft SQL Server Management Studio<\/strong><\/h3>\n\n\n\n

In this guide we shall be using Microsoft SQL Server Management Studio.<\/p>\n\n\n\n

Download SSMS HERE<\/a> <\/code><\/strong><\/h3>\n\n\n\n

Step 1:<\/strong><\/h4>\n\n\n\n

First Ensure you have created a database on Plesk.<\/p>\n\n\n\n

Login to Plesk ->Databases -> Add Database -> Fill your details and click ok.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Once completed, Click on Connection Info to preview your details as below<\/p>\n\n\n\n

For my case I have created a database name “dannydev_test1”, username as “dannydev_test1”<\/p>\n\n\n\n

and my “password” and Host as .\\MSSQLSERVER2019<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2:<\/strong><\/h4>\n\n\n\n

Open Microsoft SQL Server Management Studio.<\/p>\n\n\n\n

You will see a window as show below.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
Fill your details.<\/h5>\n\n\n\n

Note that some details will vary depending on your database Host.
See link below for the correct details depending on this.<\/p>\n\n\n\n

\n
How to Connect Remotely to MSSQL Database<\/a><\/blockquote>