Question
How to manage a database hosted in Plesk using a local database client?
Answer
-
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.151\MSSQLSERVER2017.2.3 Select the SQL Server authentication method.
2.4. Enter the login and password of a database user.
-
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.151\MSSQLSERVER2017.2.4. Enter the login and password of a database user.
-
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.2\MSSQLSERVER2017.2.3. Enter the login and password of a database user.
Comments
10 comments
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.
@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
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? :)
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.
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.
Hello,
Any update on this? any alternative to MyLitteAdmin?
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...
Any update on MylittleAdmin
there is a tool called adminer https://support.heberjahiz.com/hc/en-us/articles/12117446605330-How-do-I-manage-MS-SQL-databases-with-Adminer-on-Plesk
but its not officialy supported by plesk. the tool is aparently in beta
what we have done is put a whitelist on the sql management port and if a client wants access we add there current ip to the whitelist. but its not a perfect solution.
wish that plesk would look at alternative but as far as i can tell no one really wants a windows alternative to phpmyadmin.
two users here complain about it too https://support.plesk.com/hc/en-us/articles/12376955589399-Are-there-any-alternatives-to-myLittleAdmin-in-Plesk-for-Windows and here is a thread on the forums https://talk.plesk.com/threads/alternative-for-mylittleadmin-to-access-mssql-database.377327/
Vote on the uservoice plesk to get another tool added…
https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/40594882
I wanna ask question to Vincent you put screen shoot that user can do this this this… but after connect MS sql if user is non technical how to use query and where or GoDaddy will support for 1 month database classes. Plz reply
Please sign in to leave a comment.