How to connect the MSSQL database via sql management studio?

Microsoft SQL Server is a relational database management system, or RDBMS. In addition to using its own database storage file, Microsoft Access also may be used as the ‘front-end’ of a program while other products act as the ‘back-end’ tables, such as Oracle and Sybase in the hosting websites. Currently many of the developers use MSSQL databse in the reseller hosting websites. Web Hosting allows you to connect the database via Mssql management studio. in your Local system.

1.First Create the database in the Plesk panel,follow the steps given below;

[1] Login to plesk panel
[2] Click on Domains.
[3] Click on Domain name for which you want to create the database.
[4] Click Databases tab
[5] Click on Add New Database
[6] Fill in the database creation form and click OK

2 Then Downlode and Install the Mssql management studio in your Local system

3. Then you can add ips instantly to access your database remotely through “AddSQLIP” option in the plesk panel. To add ip addresses, follow the steps given below;

[1] Login to your plesk control panel

[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list

[3] Click on Websites and Domains option in your control panel

[4] Click on AddSQLIP button in the control panel

[5] Supply the IP Address and submit

Wait for 15-20 min to get your ip reflected in the firewall.

4. After whitelisting the IP address, you can able to connect the database by using below mentioned connection steps:

Mssql connection steps using management studio.

Server type : Database engine

Server name : server ip

Authentication : SQL server authentication

Password : database password

5. Click to connect