Articles in this section

See more

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

Avatar
Aleksei Khikhich
Updated
Follow
Plesk for Windows DoNotDelete:docref kb: how-to

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.151\MSSQLSERVER2017.

    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.151\MSSQLSERVER2017.

    2.4. Enter the login and password of a database user.
    image-2023-3-16_13-48-0.png

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

    2.3. Enter the login and password of a database user.

Comments

7 comments

Sort by Date Votes
  • Avatar
    ITCS OTE SA

    This is only applicable if the Hosting provider exposes the MSSQL server to the internet. If the MSSQL server is in the back-end, there's no way to use a local client and connect to the MSSQL server, as you could do before, using MyLittleAdmin.

    1
    Comment actions Permalink
  • Avatar
    Maarten van Lieshout

    @ITCS OTE SA: MyLittleAdmin had been removed from Plesk as of version 18.0.53:

    https://docs.plesk.com/release-notes/obsidian/change-log/#plesk-18053

     

    0
    Comment actions Permalink
  • Avatar
    Tobias Sorensson

    any alternative to MyLitteAdmin?

    we are a hosting company and we dont want to open the sql server port to the wide internet but we have to becouse the clients cant access the sql server from plesk.

    any update on this? :)

    2
    Comment actions Permalink
  • Avatar
    Permanently deleted user

    Hello Tobias Sorensson,

    We announced the drop of MyLittleAdmin in the 18.0.51 release notes and Plesk deprecation plan. For now, as there is no suitable replacement for MyLittleAdmin on Windows servers, you may consider using one of the solutions above or continue using manually installed MyLittleAdmin. Please note that the manual installation of MLA is not recommended on our side. This is because MyLittleAdmin is not in active development, and has known security issues. 

    0
    Comment actions Permalink
  • Avatar
    Tobias Sorensson

    Hello Plesk

    we hope that a replacement will be found as we dont want to expose our sql services to the world wide of the internet.

    for now we can do whitelist access to our sql server but its not a permanent solution.

    3
    Comment actions Permalink
  • Avatar
    MeR

    Hello,

    Any update on this? any alternative to MyLitteAdmin?

     

    0
    Comment actions Permalink
  • Avatar
    Riccardo Raia

    SQL Server Management studio SSMS è stato scaricato, ma plesk proprio non lo vede...
    SQL Server Management studio SSMS has been downloaded, but plesk just doesn't see it...

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles