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

    Login 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 or 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 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 login to the database editor.