Creating MySQL or SQL Server Databases for Your Hosting Account
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.
- Click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Control Panel in your hosting account, click the icon corresponding to the database you want to create.
- Click Add.
- Complete the fields. If you need more information about DSN or ASP Schema, click here. To allow direct access, click Additional Options.
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 Actions, and then Details to find more information, such as its host name.
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.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
MySQL Connection String with PHP
Locating Your Database's Host Name
Your message was successfully sent.
There was an error in sending your message, please try again.
Have a question about the content of this article?