How to create a MS SQL server database in WebsitePanel

This tutorial assumes you are already logged in to WebsitePanel

Now let's learn how to create a Microsoft SQL Server database

1) Click on the plan you want to add an SQL database to

2) Click Databases

3) Click SQL Server

4) Click Create Database

5) Enter a name for your database

6) Click Save

7) You can click on the database you just added to edit it

8) You can view existing users, information about the database files, delete or backup the database, or truncate files

9) Click Save when you are finished

Success! You can view your added databases and see how many allowed databases you've used

This is the end of the tutorial. You now know how to create a Microsoft SQL Server database in WebsitePanel

  • Thursday, 01 March 2012

Comments (2)

  • sal velasco

    sal velasco

    17 July 2012 at 21:43 |
    Note: You will be able to access your remote SQL server DB using the free SQL Management studio from your desktop over the internet.

    You must first create a SQL DB and associated SQL user in hosting control panel http://panel.hostasp.net, Web Site/ Website Properties/ Management- gives you remote website credentials: IIS Manager for Remote Administration.

    To get the remote SQL Server address, goto your Client Area, click on spaces -> select the space and then Click on "View Space Summary" link on right side of the page. This page will give you - your SQL server name, sample third party application connection string (if desired). Schroll down to find your SQL server remote URL
  • Sandilyan Ramadoss

    Sandilyan Ramadoss

    09 October 2012 at 02:29 |
    We are now supporting remote database administration using IIS remote admin. We have setup required database extension on our IIS servers. You would need to connect to your website remotely using your local IIS over, that will establish secure connection to our web server, You will be then able to use database extension with local IIS to manage your databases.

    We will soon be adding a article on IIS remote admin and database manager through IIS extension. For more details and information visit http://www.iis.net/downloads/microsoft/database-manager

Leave a comment

You are commenting as guest.