How do I administer Microsoft SQL Server within Plesk?

This article will explain how to administer Microsoft SQL within Plesk.

Please note: You must have purchased Power pack and updated your product key before you can use Microsoft SQL.

This article was originally created for our previous generation of Virtual Private Servers. As such, these instructions may not be relevant to our current generation of Virtual Private Servers.

Step 1 of 10

Log in to your Plesk panel.

 

Step 2 of 10

Click on the Subscriptions link under the Hosting Services section.

Step 3 of 10

Click on the Open in Control Panel link for the subscription you wish to add, edit, delete or access a MSSQL database on.

Step 4 of 10

Click on the Websites & Domains tab.

Step 5 of 10

Click on the Databases option.

Step 6 of 10

Now, create a new database by clicking on the Add New Database button.

Step 7 of 10

Make sure to select type as Microsoft SQL Server and ensure the Database server is set to the default for MS SQL. When finished click the OK button.

Step 8 of 10

Now click on the Add New Database User button to add a user.

Step 9 of 10

Enter a User Name and Password, then click on the OK button.

Step 10 of 10

You can now click on the Webadmin button to log in to the database editor.

Related Support Material:

  1. How do I install Microsoft SQL Server Express on my VPS?
  2. How do I access my Microsoft 365 dashboard?
  3. How do I reset the password for my Microsoft 365 package?
  4. How do I download or back up my files and folders in Microsoft 365?
  5. Enable PHPMail logging in Plesk Windows
  6. Using Plesk Migrator to move data between 123 Reg Virtual Private Servers