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
1 comment
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.
Please sign in to leave a comment.