Question
How to manage a database hosted in Plesk using a local database client?
Answer
SQL Server Management Studio (SSMS)
-
Download SQL Server Management Studio.
Once the download is complete, run the setup file and follow the on-screen instructions to complete the installation. -
Connect to a SQL Server Instance:
2.1. Open SQL Server Management Studio. You'll be prompted to connect to a SQL Server instance.
2.2. Enter the server's IP address, for instance,10.69.43.151MSSQLSERVER2017.2.3 Select the SQL Server authentication method.
2.4. Enter the login and password of a database user.
HeidiSQL
-
Download SQL HeidiSQL.
Once the download is complete, run the setup file and follow the on-screen instructions to complete the installation. -
Connect to a SQL Server Instance:
2.1. Open HeidiSQL. You'll be prompted to create a session.
2.2. Select the Microsoft SQL Server (TCP/IP) network type.
2.3. Enter the server IP address, for instance,
10.69.43.151MSSQLSERVER2017.2.4. Enter the login and password of a database user.
mssql for Visual Studio Code
-
Download and install the plugin from the official marketplace.
Once the installation is complete, open the SQL server tab in VS Code. -
Connect to a SQL Server Instance:
2.1. Click the add connection button and follow the connection wizard.
2.2. Enter the server IP address, for instance,
192.0.2.2MSSQLSERVER2017.2.3. Enter the login and password of a database user.
with