Setting up a SQL Server Database on Your Hosting Account
SQL Server is a relational database server from Microsoft that you can use in conjunction with Web programming languages to create dynamic Web sites.
To Set up a SQL Server Database for Your Web Site
- 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 SQL Server icon.
- Click Create New Database.
- Enter a description.
- If you want to use DSN with this database, select Create DSN.
- If you want to use an ASP Schema with this database, select ASP Schema.
- Enter a database name.
- Enter a user name and password.
- Specify whether you want to allow Direct Database Access.
NOTE: Direct Database Access is a less secure way to manage your hosted databases which most users do not require. If you do not need to access your database remotely, then you should not enable Direct Database Access. For more information, see Why Connect Remotely to Shared Hosting Databases.
- Verify your SQL Server database settings. If everything looks OK, click OK.
It may take a few minutes to create your database. Click the Refresh button in your browser to check and see if your database is ready.
Once you have set up a database for your account, you can click on the Pencil icon next to the name of your database to find your host name information.
To access more advanced management functions, click Open Manager next to the database you want to configure.