To connect the MS SQL Database remotely please follow the below steps:
1: Firstly you need to Download the "SQL SERVER MANAGEMENT STUDIO" from the link: https://filehippo.com/download_sql_server_studio/
2: Once your setup of the Studio is installed open your Management studio and fill the details like server name, Authentication, user name and password.
3: You can get all the information from the Option Databases in right corner of your plesk.
4: Choose any database which you want to connect to Studio and click on "connection info" from here you will get the SERVER NAME.
5: The Authentication will always be " SQL SERVER AUTHENTICATION ", User/Password will be your database user and password only.
6: Once you done click on CONNECT and your database will be connected to the SQL Studio.
NOTE: **OUR PLESK ONLY SUPPORT SQL STUDIO SERVER MANAGEMENT VERSION 2008&2012 ONLY**