You must create SQL Databases and Database user on the Database server before your Website or Web application can use SQL Server Databases in the hosting environement.

To create a SQL 2005 Database, follow these steps:

1. Log in to the Hosting Control Panel
2. Select the Hosting Package
3. On the left menu, select Databases -> SQL Server 2005
4. Next page, select 'Create Database'
5. Next page, enter a Database name and click on 'Save'
6. On the next page, click 'Create User' button to create a database user
7. Enter Database User Name and Password
8. Select the Database as the 'Default Database'
9. Select the check box next to the Database name under the 'Databases' section
10. Click 'Save'

Now that the Database and a user is created on the Server, you are ready to deploy your initial Database to the server.

See Publishing SQL Server Database to the Hosting Environment

Note:

1. The SQL Server 2005 menu option is only available if your hosting package includes SQL Server databases
2. If there is more than one Databases included in your hosting package, you can use multiple databases for one Website, or one Database for multiple Websites, it does not matter.
3. If you have create multiple Databases in your hosting space, you do not need to create multiple database users. You can use a single database user with all the databases. Make sure to assign the user to all the databases in the hosting control panel
4. You can use the SQL Web Admin Tool to create ASP.NET Membership and Profile objects (Tables, Views and Stored Procedures) in any SQL Database