Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

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

 
databasedatabaseshostedipmarketplace

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

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

Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

WordPress Development at Your Fingertips with Codeable

Read More »

Plesk with Centralized Database and Network File System

Read More »

Full Site Check now scans for Google Fonts

Read More »
Knowledge Base

How to add an already installed Microsoft SQL server in Plesk

Read More »

How to enable remote connections to MS SQL server on a Plesk server?

Read More »

Warning on the “Database Servers” page in Plesk: Unable to determine the TCP port number used by Microsoft SQL server

Read More »

Plesk database servers menu shows warning: Unable to determine the TCP port number used by Microsoft SQL server ‘localhost’

Read More »

Hosting Wiki

  • Server Redundancy
  • PostgreSQL
  • Bare Metal Server
  • MySQL
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • JavaScript
  • MSSQL
  • SQL
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • IPv6
  • IPv4
  • SIP
  • UDP/IP
  • Network Bandwidth
  • TCP/IP
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family