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.
- In the My Products section, select Hosting.
- Next to the hosting account you want to modify, click Manage Account.
- 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.
- Verify the settings and click OK.
NOTE: If you need to Allow Direct Database Access, but do not see the field, contact customer support. If you are not sure what Direct Database Access is, see Why Connect Remotely to Shared Hosting Databases
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
How do I import data into a MySQL database?