Control Panel Login

Databases - SQL Overview

An SQL Server is a high performance database server available to our customers that is designed for high traffic and large databases.

You may setup your SQL database directly from the manage DSNs section of the hosting control panel.

To access the SQL database you can use any database management software, such as Microsoft Access, Visual InterDev, or the SQL Enterprise Manager.

If you are using Microsoft Access or Visual InterDev you will be connecting to the SQL via an ODBC connection, which requires you to create a Data Source Name on your local computer. To do this follow these instructions:

  • Go to your ODBC section on your computer and open it. In Windows 95/98/NT, your ODBC settings can be found in your administration page.
  • Add a System DSN. It does not make a difference, the decision is up to you.
  • Click the "add" button, and then select the SQL server driver. If you do not have this driver you must get it in order to make a connection to the SQL server. You can get this driver by going to Microsoft's Web site at http://www.microsoft.com/SQL/.
  • After it displays the information on the DSN you are setting up, it will ask for the server location. In this field, type in SQL.TERRASITE.COM. It also asks for a username and password, type in the one used when setting up the SQL database in the hosting control panel.
  • Click the "option" button. You will see a series of dropdown boxes. Find the box labeled database and click the down arrow. If your ODBC driver is working correctly you should see a list of databases, and yours will be highlighted.


If you are using SQL Enterprise Manager, you need to follow these instructions:

  • Open the SQL Enterprise Manager.
  • Click "Server", "Register Server".
  • Once the dialog box is open fill in the fields. In the server field, type in SQL.TERRASITE.COM.
  • Fill in the login information with the username and password that you used when setting up the SQL database in the hosting control panel.
  • Once all the information is entered press the "register" button, this will make contact with our SQL server. Now that you are connected you can add tables and manipulate your information as you wish.