How to connect MS SQL database using SQL Management Studio?

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**

  • 0 Users Found This Useful
Was this answer helpful?