Setting up a MySQL or SQL Server Database for Your Hosting Account
Here's the Lowdown: Windows hosting supports MySQL, MS SQL (SQL Server) and Access databases while Linux only supports MySQL. This article covers MySQL and MS SQL; Access databases are covered in this article.
To Set Up a Database for Your Website
- Log in to your Account Manager.
- From the My Products section, click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Hosting Control Center, click the icon corresponding to the database you want to create.
- Click Create Database.
- Complete the fields. If you need more information about DSN or ASP Schema, click here.
NOTE: If you need to Allow Direct Database Access, but do not see the field, contact customer support. Direct Database Access is only available on paid hosting plans. If you are not sure what Direct Database Access is, see Why connect remotely to hosting databases?.
- Verify the settings and click OK.
It takes up to 1 hour to create a database.
Once the database is created, you can click the Pencil icon next to the database to find more information, such as its host name.
More Information About DSN and ASP Schema
DSN
The purpose of the Windows file DSN (data source name) is to centrally store your database connection information. If you have many Web pages that require database access, this feature enables you to simply reference the path of the file DSN instead of having to provide the database connection details on every page.
ASP Schema
ASP.NET configuration schema contains elements that control how ASP.NET Web applications behave.
For information about importing data into your database, see:
Importing Data Into a SQL Server Database
Importing Data into MySQL Databases
