What are the steps to remotely manage my SQL Server 2019 or SQL Server 2022 database with SQL Server Management Studio? Print

ssms, sql server management studio, sql remote database manage
0

This article covers 3 steps needed to connect to your hosted Microsoft SQL Server database with Adaptive.

Step 1: Install SQL Server Management Studio (SSMS)

Download and install the last version of SQL Server Management Studio

Step2: Find your Database Information

When you create a database in the Plesk Control Panel you give the database a name and username and password. This is the information you'll need to connect.
Note the SQL server hostname was sent to you in the Welcome Hosting Account email when your account was created; for example sql2022.adaptivewebhosting.com.

Step 3: Connect to your database using SSMS

Launch Microsoft SQL Server Management Studio
The Server type should be Database Engine
Enter the server hostname (see above)
Authentication is SQL Server Authentication
Enter your database username (see above)
Enter your database password (see above)
Click Connect
Find your database in the list to manage.

If you have any questions let us know and open a support ticket.

Was this answer helpful?

Related Articles

Managing File Permissions using the Plesk File Manager If you are getting permission denied errors on your website, it's possible that you need to allow... Error when accessing a WCF service: "This collection already contains an address with scheme http. There can be at most one address per scheme in this collection." For ASP.NET 4.X, add the following lines to your web.config: <system.serviceModel>... HTTP Error 500.35 - ANCM Multiple In-Process Applications in same Process You receive the error message HTTP Error 500.35 - ANCM Multiple In-Process Applications in same... Upgrade ASP.NET Core Web 3.1 app to ASP.NET Core 5 To Upgrade ASP.NET Core Web 3.1 app to ASP.NET Core 5, follow these steps. Download and... How do I Install an SSL Certificate on my Website? To install a Free Lets Encrypt SSL Certificate perform the following steps: Login to your...