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

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/hostname, for instance,  windows.cheaphosting.pk.\MSSQLSERVER2016

    2.3 Select the SQL Server authentication method.

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

  3.  Set Encryption as "Optional".
    Click Connect.

image

  • mssql database connection, mssql server management studio, mssql database client
  • 0 Пользователи нашли это полезным
Помог ли вам данный ответ?