How do I administer Microsoft SQL Server within Plesk?

This article applies to 123 Reg Windows VPS hosting running 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.

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.