How do I add a SQL database to my account?

The following article explains how to add a SQL 2005 or SQL 2008 database to your hosting account through the Control Panel by either creating your initial SQL database or purchasing an additional SQL database. You can only add a SQL database if your hosting plan includes SQL. If you wish to purchase an additional SQL database to add to your current hosting account, you have the following plans to choose from:

• SQL Plan $15/mo: 600MB data storage, 225MB transaction log storage
• SQL 1 GB Plan $25/mo: 1050MB data storage, 450MB transaction log storage

To add your initial SQL database, please follow these steps:

1. Open a browser window and go to www.HostMySite.com.
2. Click on Control Panel Login.
3. Log into the Control Panel as the Account Administrator and select the appropriate domain.
4. Click on Database Administration and select Add a SQL Database.
5. Enter the appropriate information:
   • Desired Username: enter a username for your database
   • Desired Password: enter a password for your database
   • Confirm Password: re-enter the password for your database
   • Desired Database Name: enter a name for your database
   • SQL Version: select SQL 2005 or SQL 2008
   • Add a DSN?: check this box if you wish to have a DSN created for the database
   • Name of DSN: enter a name for your DSN if you wish to have one created for the database
   
6. Click Add SQL Database.

To purchase and add an additional SQL database, please follow these steps:

1. Open a browser window and go to www.HostMySite.com.
2. Click on Control Panel Login.
3. Log into the Control Panel as the Account Administrator and select the appropriate domain.
4. Click on SQL Server and select Add a SQL Database.
5. Select MS SQL Server and click Continue.
s
6. Select the version of MS SQL and click Continue.
7. Enter the appropriate information:
   • Database Name: enter a name for your database
   • DB Login: enter a username for your database
   • DB Password: enter a password for your database
   • Confirm Password: re-enter the password for your database
   • Database Plan: choose the SQL plan you would like
   
8. Click Add SQL Database.