How to integrate the MS SQL with the Plesk (Web Pro Edition) & (Web Host Edition)?

If you have already installed MSSQL on the server and want to manage the MSSQL Databases from the Plesk panel, you will need to integrate the MSSQL in Plesk. Once you are done with the following steps, you can handle the MSSQL Databases directly from Plesk. You can manage this integration with Plesk Web Pro (with 30 Domains) & Plesk Web Host edition (with unlimited domains).

 

  1. Login to the Plesk using http://IPAddress:8880

  2. Go to the Tools & Settings >> Applications & Databases >> Database Servers.

Find-Database-server

  1. Click on the Add Database Server.


(A) General :

      Database server type : MSSQL
      Host name or IP address: Server IPAddress


(B) Authentication :

      Administrator's username: sa
            Administrator's password : sa user password
            Confirm password: sa user password


Add-Database-Server-DetailsAdd-Database-Server-Details

  1. Click on OK Button.


Once you have done this, you can create a database from the Plesk Panel and verify it from SQL management studio.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

how to delete an email account from the Plesk panel?

This article will help you how to delete an email account from the Plesk panel. Login into...

How to change the Default limit of outgoing messages from a mailbox in plesk?

Sometimes your mailbox created in the Plesk Panel reach the default outgoing message limit. and...

A website hosted in Plesk for Windows fails to load: The FastCGI process exceeded configured activity timeout.

If your website is hosted on the Plesk Panel, you may find the below error in the web-browser....

How to set Plesk Panel Runnig Behind a Router with NAT?

If we install Plesk in Amazon VPS, we have to bind NAT address to public static IP address from...

What is website copying in Plesk?

Plesk Panel allows you to set up a website staging environment to check that everything runs...