How do I add a MSSQL database to my site?

Knowledgebase

Net Access > Customer Support Help Desk > Knowledgebase

How do I add a MSSQL database to my site?

Solution If you are setting up the domain for the first time and following the "How do I add a website?" you will add the storage space at step 7 on the "Additional Features" selection screen.

1. In the "Microsoft SQL Storage" section, select the option that best corresponds to the amount of storage you would like to us. If the amount you want is not available, you would then need to contact Sales and possibly upgrade your package.
2. Under the "Databases" section choose the number of databases you will need.

If you have already setup the domain and need to add the MSSQL storage you will follow these steps:

1. Log into your control panel at http://www.websitesettings.com
2. Click on "Hosting" on the left navigation menu and then click on "Cloud Sites".
3. Click on the domain you want to add a MSSQL database to.
4. Click on the "Change Plan" link in the Traffic & Disk Space section.
5. Skip the "Select A Hosting Plan" page by scrolling to the bottom and clicking on the "Next Step" button.
6. On the "Additional Features" page in the "Microsoft SQL Storage" section, select the option that best corresponds to the amount of storage you would like to us. If the amount you want is not available, you would then need to contact Sales and possibly upgrade your package.
7. Under the "Databases" section choose the number of databases you will need.
8. Click on the "Next Step" button.
9. Review your selections and when ready, click on the "Next Step" button.

Now that you had added the storage space to the domain, you can now add the MSSQL database.

1. Log into your control panel at http://www.websitesettings.com
2. Click on "Hosting" on the left navigation menu and then click on "Cloud Sites".
3. Click on the domain you want to add a MSSQL database to.
4. Click on the Features tab.
5. Click on the "Add" button in the "Databases" section.
6. Enter the name of your database in the text field and select "SQL Server 2005" from the "Database Type:" drop down menu, then click on the "Continue button.
7. Enter the database username and password you would like to assign then click on the "Finish" button.

Was this article helpful? yes / no

Article details

Article ID:	90
Category:	Cloud Hosting
Date added:	2009-09-05 15:31:32
Views:	35
Rating (Votes):	(4)

<< Go back