Plesk

How to manage a database hosted in Plesk using a local database client?

Question

How to manage a database hosted in Plesk using a local database client?

Answer

SQL Server Management Studio (SSMS)

  1. Download SQL Server Management Studio.
    Once the download is complete, run the setup file and follow the on-screen instructions to complete the installation.

  2. 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.

    image-2023-3-16_13-32-52.png

HeidiSQL

  1. Download SQL HeidiSQL.
    Once the download is complete, run the setup file and follow the on-screen instructions to complete the installation.

  2. 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

  1. Download and install the plugin from the official marketplace.
    Once the installation is complete, open the SQL server tab in VS Code.

  2. 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.

Exit mobile version